Default bases on selection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 fields, Product Name and Price in a form. They're both in the
Product table.
How do I get the price to come up after I selected the product name from
combo box?
 
Ashley,
You should add Price to a second column in your combobox.
Then, on the AfterUpdate of your Combo (cboProductName)...(use your own
control names)

[YourPriceField] = [cboProductName].Column(1)

In a combobox, the first column is 0, the next 1...etc.
hth
Al Camp
 
Back
Top