how do I create a form that selects a state & then only show that state's cities

  • Thread starter Thread starter bayouplayer
  • Start date Start date
B

bayouplayer

I am trying to create a form that has a drop down list for state and city.
But I want to only show the cities for that state. Example: if I choose GA,
the next dropbox will only show all the cities for GA. Should I create a
different table for each state? Or should I create a query that only show the
cities that have the "statename" in the prev text box labled "state".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

populating one combo box based on another 2
User Login Filter 1
continous form combobox 8
Query Form 1
code to auto-complete a form? 1
macro that will fill in state and zip when a certain city is typed 6
Adding to a Table list using a Form 1
Cascading List Boxes 6

Back
Top