One combo boxe influece another

[Knight of Nee]

Hi

How can I make it so that a selection in one combo box on my form changes what’s displayed in the other? For example I have many suppliers and many products stores in different tables with pricelist table linking them.

The first combo I want the user to select the supplier they want to use. This should then limit the second box to ONLY the products that this supplier supplies. Can someone explain how this is done?

Thanks
Craig

 

[Corticus]

Open the form containing the combos you mentioned. View the properties for the combo that should be filtered of the other combo. Under Data|Rowsource, right click in this area and bring up the query builder. As the first column of the query, add the field you want to see in the combo. Then add the field by which you want the combo filtered. Right click on the criteria for this field, and use the expression builder to browse to the combo on which this combo should be filtered. Close the query builder and tell it okay.

Finally, add a 'afterupdate' event to the first combo, and have it requery the combo that needs to be filtered.

That should do it, hope that helps,

 

[totem_pole]

Hi Corticus

I have the same problem but cant follow your steps to get a solution. I cant bring up the query builder, can you help?

Kind regards
Michael Mullineux

 

[alansidman]

Michael
Here is a tutorial on how to do Cascading Combo Boxes in Access

Access Tips: Cascading Lists for Access Forms