467,914 Members | 1,801 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Dependent Combo Boxes between two tables

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?
4 Weeks Ago #1
  • viewed: 996
Share:
3 Replies
NeoPa
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.
4 Weeks Ago #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.
4 Weeks Ago #3
NeoPa
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.
4 Weeks Ago #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
By using this site, you agree to our Privacy Policy and Terms of Use.