Dependent Combo Boxes between two tables

wisper1977

I have two combo boxes, one is make and the other model. The Make combo pulls from a make table, and the model combo pulls from the model table (which has make and model fields). I want to have the Model Table to only show those models that match the Make Combo. How can I do this?

4 Weeks Ago #1

NeoPa

This sort of question comes up a lot so has already been answered a number of times.

Try Cascaded Form Filtering. That explanation covers a situation that's even more than you need so you should find what you want there.

4 Weeks Ago #2

wisper1977

Thank you, It sucks not knowing terminology. I had been searching for just about everything I could think of. Would have never guessed that.

4 Weeks Ago #3

NeoPa

My pleasure. You make a very good point. Often the ability to search for something - Sometimes referred to as Google-Fu - comes down to knowing which terms to use when looking.

Certainly, when selecting records, it's referred to as filtering as that is what goes on under the hood. Cascading is really just about making the contents of one or more of your filtering controls filtered too. Thus, a filter can apply to the recordset of the form as a whole, as well as, and optionally, the recordset of other filter controls.

4 Weeks Ago #4