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?

[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.

[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.

[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.