Using Zip Code Database

[Guest]

sI need help on with Zip Code Lookup DataBase.
I have a database with postal zip codes, cities and states

I want to be able to have the user enter the zip code and it automatically
fill-in the city and state fields associated with that zip code.

What coding should I use. DLookup??

Thank You

 

[Rick B]

The lookup wizard will write this code for you.

 

[Guest]

Lookup field created by Lookup wizard does not work on the form view leve.
Only works on the table view.
It only displays one column of fields not three.

 

[John Vinson]

sI need help on with Zip Code Lookup DataBase.
I have a database with postal zip codes, cities and states

I want to be able to have the user enter the zip code and it automatically
fill-in the city and state fields associated with that zip code.

Typically you would not want to store the city and state. You can
*display* them by including the fields in the Combo Box's RowSource
query (and set the number of columns of the combo to include them
all); put textboxes on the Form with control source

=cboZip.Column(2)

to display the *third* (it's zero based) field in the query bound to
the combo box cboZip.

John W. Vinson[MVP]

 

[John Nurick]

Typically you would not want to store the city and state.

I know that this won't work in Australia, where several places may share
the same postal code. In the US, is it safe with 5-digit ZIP codes, or
does it require ZIP+4?

 

[Rick Brandt]

I know that this won't work in Australia, where several places may
share the same postal code. In the US, is it safe with 5-digit ZIP
codes, or does it require ZIP+4?

If you're asking "Are there zip codes with more than one city?" the answer is
Yes. I do not know if Zip+4 solves that problem.

 

[Guest]

Thank you John,,

This works. Orginally I had a field name typo.

 

[John Vinson]

I know that this won't work in Australia, where several places may share
the same postal code. In the US, is it safe with 5-digit ZIP codes, or
does it require ZIP+4?

There are zipcodes with more than one city - but in all such cases the
Post Office has a single "preferred" city. I've actually built address
modules both ways, with and without formally "redundant" city names;
my current two biggest projects have the city and state stored in the
address table.


John W. Vinson[MVP]