subform called by value list entry

[gpbuckley]

I have three material categories on a drop down (value list) on a form. Based on whichever category is chosen I want a sub form to open which will have criteria specific for the chosen category. For example if user picks circuit board category a new sub form with specific items for that category should be displayed. Could you advise the best method to do this?

Thanks again – this forum is great and has been of much assistance.

 

[Trevor G]

create a form which has the combobox in it, then I would create a query and in the catergory I would point it to the combox list, then add a subform based on the query so that when you select a catergory it will filter the subform.

In the query and the catergory field go into the criteria option below its name, then look for an icon which is the build wizard and then select the icon, then find the form on the left side, and then select the combobox Save and close the query.

On the form then select to go into design view and then press f11 on the keyboard to show the navigation payne and drag the query into the form. Behind the combo box you need to add a small amount of code which will requery the subform.

I have created a small example for you.