combobox - onfocus

[deekras]

i have a table that has a list of counties, states and zip codes. i have a form that asks the user for the state, when the state is displayed, i want it to show a combobox to show all the counties in that state. then when the cursor is on one particular couty, i want a listbox to show all zip codes in that state & county.

how do i make that happen?

 

[ColinEssex]

In the "solutions" database that comes with Access they have examples of cascading comboBoxes - I think this what you would require.

If you do a search in the forums, I think that there has been some examples posted here too.

Hope this helps

Col

 

[deekras]

i did search the forum, i didn't find anything. maybe i don't know what to search on. i don't have solutions on my computer. please guide me.