dependent combo boxes



I am using access 2003. I have a table called state that lists states. I have
a table called cities that has cityid, state( a lookup in the state table),
and city . THis table contains states and then cities within each state.

I have a table customer that lists ,
customerid,firstname,lastname,address,city,state,and zip.

I create a form based on the customer table but omit the city and state
fields. In the form which I call customer, I go to design view. I create a
combo box for state that merely pulls states from the state table. I name it
combostate. I store the value in the state field. I name the query querycity.

ON the customer form I create another combo box based on the querycity and
only pull the city field in . I store the value in the city field. I name it

I go to the combostate and go to proprrties and go to after update. In the
after update I make event procedure that says combocity.requery
I create a query based on the city table and only use the city and state
fields. IN the criteria for the state field, I use

This technique works great. when I choose a state only the cities in that
state populate the city box.

Now the prblem. When I repeat the process trying to get a zip combo box that
is dependent upon the cities chosen in the comboity. It doesn't work it says
it is too complex. Any suggestions or workarounds would be much apreciated.




Arvin Meyer [MVP]

Multi-posting, especially with different subjects will not get you an answer
any quicker. Instead cross-post the same post to the 2, or in rare cases, 3
newsgroups that are relevant.

Your answer is in the main newsgroup, I'll let you look through them to see
why cross-posting is more advantageous.

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

combo box help 3
populating one combo box based on another 2
Auto Fill 0
Unbound Combo Box 5
Combo box help! 3
Duplicate data on combo box 7
Form help 4
Combo box problem 7