470,814 Members | 881 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,814 developers. It's quick & easy.

Dependent Combo Boxes between two tables

2 2Bits
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?
Feb 1 '21 #1
3 1230
32,311 Expert Mod 16PB
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.
Feb 1 '21 #2
2 2Bits
Thank you, It sucks not knowing terminology. I had been searching for just about everything I could think of. Would have never guessed that.
Feb 1 '21 #3
32,311 Expert Mod 16PB
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.
Feb 1 '21 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by me | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.