Blue
White
Purple
Green
Red
Orange
Blue Light
White Light
Purple Light
Green Light
Red Light
Orange Light
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?
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.
Worked perfectly. Thank you.