Using Zip Code Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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.
Click to expand...

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]
 
Typically you would not want to store the city and state.
Click to expand...

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?
 
John said:
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?
Click to expand...

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.
 
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?
Click to expand...

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]
 
Back
Top