This topic is locked

Display ancillary fields from dropdown selection

3/16/2006 1:40:48 PM
ASPRunnerPro General questions
B
bceglia author

I have a table of items in Access that has a ProductId (dropdown) and other fields. I would like to automatically display the price, description and deminsion fields when the ProductId is chosen from the dropdown.
Can anybody help?

Sergey Kornilov admin 3/17/2006

Bill,
you can do it using dependent dropdown box on the Edit format dialog on the Formatting Tab.

Select Lookup wizard for price field, description field etc. on the Edit as dialog, check off This dropdown is dependent on and set required value.

B
bceglia author 3/20/2006

Worked perfectly. Thank you.