Combo box populated by selection in other combo box

[Master Klick]

I have a form with a number of combo boxes to select criteria in order to narrow down a list. A selection in any combo box should narrow your options in the other combo boxes.


For example:

Combo 1 is a list of all the states
Combo 2 is a list of all the cities

Selecting NY in combo 1 will change the list in combo 2 so that it only shows cities in NY
Or, selecting Rochester in combo 2 first will edit the list for combo 1 to show only states that have a city named Rochester

The point in me doing this is to be able to narrow down a list of over 230000 different but similar items by varying criteria in order to track inventory and value.
Scrolling through the whole list, typing criteria in manually each time and building new queries and reports every time I need to find something specific are not options.

I just need the combo boxes in a form to set the criteria to filter out the list in real time. Each selection made needs to narrow your options for the next selection.

[RuralGuy]

Search for Cascading Combo Boxes.

[June7]

Are these unbound comboboxes used to input criteria to filter a form recordset?

Here is example of cascading comboboxes: http://datapigtechnologies.com/flash...combobox2.html

Here is example using input into comboboxes as criteria for a parameterized query:
http://datapigtechnologies.com/flash...earchform.html
http://datapigtechnologies.com/flash...tomfilter.html
http://datapigtechnologies.com/flash...mtoreport.html

[Master Klick]

Thanks for the help guys. All your info helped.