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...