Help with Ms Access 2007 Combo boxes
Posted
by Yaaqov
on Super User
See other posts from Super User
or by Yaaqov
Published on 2010-03-31T21:19:54Z
Indexed on
2010/03/31
21:23 UTC
Read the original article
Hit count: 642
What's the most efficient way to "chain" combo/boxes in an Access 2007 form, so that the result of the first affected the contents of the second? I already know how to associate a combo box on a form with a query.
Here's a example of my scenario:
cmbCarMake
Behavior: User starts typing, and list shows all manufacturers in a table starting with those characters (e.g., "Ford")
cmbCarModel
Behavior: Once cmbCarMake has a selected a Make, this object will limit the possible models the user can search for by only displaying models from that one manufacturer. (e.g., "F-150")
Thank you for any examples/links.
© Super User or respective owner