zipcode fills in city

[Guest]

I want to type in the zipcode in a cell and have it fill in the city and
state cells. I was able to figure that out pretty simply in Lotus Approach,
but can't in Access. However my online mailing list uses Access 2000 and
it's a bother to transfer back and forth, so I'd like to just use Access.
Are there any tutorials out there? I'm sure others use Access for this sort
of stuff all the time. I'm just not getting it.

 

[John Vinson]

I want to type in the zipcode in a cell and have it fill in the city and
state cells. I was able to figure that out pretty simply in Lotus Approach,
but can't in Access. However my online mailing list uses Access 2000 and
it's a bother to transfer back and forth, so I'd like to just use Access.
Are there any tutorials out there? I'm sure others use Access for this sort
of stuff all the time. I'm just not getting it.

There are a couple of ways to do this; one is to use a Combo Box to
select the zipcode from a table containing zipcodes and city names.
Your table would not contain the city name field at all - instead, you
would have a textbox with its Control Source set to

=cboZip.Column(1)

where cboZip is the name of the combo box, and (1) means the *second*
column - it's zero based.

Also check the address handling in the Northwind sample database; or,
most of the good Access books available (Running Microsoft Access by
John Viescas, The Access Bible by Prague, Using Microsoft Access
published by Que, etc. etc.) will touch upon this issue, among others.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps