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: 615

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

Related posts about microsoft-access-2007

Related posts about forms