G
Geofridu
Kinda new to Access. Using the Office 2000 version.
I am working on a database to use as a contact list manager. The current
question deals with setting up a form where the user selects a state from a
combo box. The user can then either select a city from another combo box or a
zip code from yet another combo box. With the city or the zip code, the user
will 95% of the time select more than one option and could select up to 10 to
15. These selections will then feed a query to pull the contact information
for those areas selected and feed them to a report.
Q1 - Once the state is selected, is a combo box the best option to continue
to drill down to the data the user is looking for?
Q2 - If not, would a list box work better or should a subform be used to
list the city/zip code information? If so, what would be the best way to
feed the query with the criteria from the selections?
Thank you in advance for your help and advice!
G
I am working on a database to use as a contact list manager. The current
question deals with setting up a form where the user selects a state from a
combo box. The user can then either select a city from another combo box or a
zip code from yet another combo box. With the city or the zip code, the user
will 95% of the time select more than one option and could select up to 10 to
15. These selections will then feed a query to pull the contact information
for those areas selected and feed them to a report.
Q1 - Once the state is selected, is a combo box the best option to continue
to drill down to the data the user is looking for?
Q2 - If not, would a list box work better or should a subform be used to
list the city/zip code information? If so, what would be the best way to
feed the query with the criteria from the selections?
Thank you in advance for your help and advice!
G