autofill

[Mr. Jangles]

Sorry for being green, I am creating a simple database that will track
inventory and create purchase orders and receipts. In the purchase order
form, I would like to be able to select the inventory item from a drop down
menu (which I can do) then I would like it to autofill in the description
and the purchase price. How do I set up description and purchase price to
be filled in? Please help, I'm green....

thanks

Mr. Jangles

 

[Albert D. Kallal]

Just make sure that your combo box displays the inventory item, description,
and purchase price. For the following to work, you need to show all 3
columns in the combo box. (so, you might want to re-build the combo box
with the wizard). Then, in the combo box after update event, you can use:


me.Description = me.comboBox.column(1)
me.Price = me.comboBox.column(2)