Hi everyone,
1. I have a table with addresses (tblAddresses)
<street>
<City>
<State>
<Zip>
etc.
2. A lookup table with all the states (lkupStates)
3. On a search form I have:
-A combo box (cboStates) - this does a SELECT DISTINCT on [States] in tblAddresses.
-A multi-select list box (lstCities) - this displays SELECT DISTINCT on all cities in tblAddresses that = value selected in cboStats
-A button (cmdFilter) that opens a query filtered by the cities selected in lstCities
Question: Can any help me figure out how can I change cboStates to a multi-select list box so the user can select more than one State and see the matching cities in lstCities?
This is going to be a huge table, so effeciency is crucial.
Thank you all very much,
Jenny
1. I have a table with addresses (tblAddresses)
<street>
<City>
<State>
<Zip>
etc.
2. A lookup table with all the states (lkupStates)
3. On a search form I have:
-A combo box (cboStates) - this does a SELECT DISTINCT on [States] in tblAddresses.
-A multi-select list box (lstCities) - this displays SELECT DISTINCT on all cities in tblAddresses that = value selected in cboStats
-A button (cmdFilter) that opens a query filtered by the cities selected in lstCities
Question: Can any help me figure out how can I change cboStates to a multi-select list box so the user can select more than one State and see the matching cities in lstCities?
This is going to be a huge table, so effeciency is crucial.
Thank you all very much,
Jenny