Feb 10, 2012
I have a database and a user form. Lets assume the database hosts a list of all cities in North America in column C, with that city's state/prov. in column B, and in column A, that state/prov.'s country.
View 1 Replies
In the user form, the user will select from the available list in the first combobox either Canada or United States. Based on the selection from combobox1, combobox2's rowlist will contain only the states, or provinces, based on the filtered data. The database will be filtered based on column A, column B now shows only the states or provinces it the US or Canada is chosen respectively.
Based then on the selection in combobox2, the user selects from combobox3, only those cities found in that state or province ... information gathered from a filter of column A (country), column B (state).
Basically, with each combobox selection, the database is being filtered.