autofill

  • Thread starter Thread starter Mr. Jangles
  • Start date Start date
M

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
 
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)
 
Back
Top