Help Needed with Design Function

[Guest]

when I enter a person using a form I want to enter their zip code and have
access automatically display the region in which the person lives.

 

[Guest]

That might be a nice feature. Do you have a table that relates zipcodes to
regions?

 

[janequilts2]

First you to you need to define your regions. Are they a group of states or
cut across states or areas within a state or ....? Your list of regions
will then determine the information you need to put in a table for the zip
code look up. I had to do survey data based on zip code and purchased a
database from the US Postal Service. I needed to do region and metropolitan
areas.

If your regions are based on specific state, have the state be the
relationship to the region instead of the zip.

If the regions are general nationwide, consider the first 3 digits of the zip.
....here's a document that gives the region for the first 3 digits -
www.usps.com/purchasing/_rtf/3digitzipcodes.rtf.

As far as the form goes.....you may need to have a query or some SQL behind
it to display immediate lookup unless you have a lookup field.....