ZIP codes in form

[Nicole Wolcott]

I would like to be able to simply type in the zip code and
have my form automatically fill in the corresponding city
and state fields and for those zip codes with more than
one city, I would like a drop down list so that I can to
chose the city. I have a zip codes table already build
with fields for Zip, City and State in that order and my
form already draws from the zip codes table so that I
don't even have to finish typing the zip code...this is
all I have so far and I feel like I have hit a wall. I can
usually figure out what to do if I am pointed in the right
direction. Any comments or suggestions would be greatly
appreciated.

 

[Sandra Daigle]

Hi Nicole,

This is really just a matter of synchronizing combo boxes - basically that's
a fancy way of saying that you make the rowsource of the second combo
dependant on the value of the first combo. Even if there is only one city
related to a particular zipcode, you can still present the data in a combo.
Here's a KB article that describes how to synchronize two combos - post back
if you need more help or further explanation.

ACC: How to Synchronize Two Combo Boxes on a Form (97624)
http://support.microsoft.com/default.aspx?scid=kb;[LN];97624