Hey. New to access 2007 and slowly learning my way around. Is there a function to provide a state lookup table when entering addresses or do I need to create my own? Or better yet, type in the Zip code and have the system provide the state? Thanks! Mark

If you want a state lookup table, you'll need to create it, or import it from somewhere. For a zip code lookup table, the same is true. The values have to come from somewhere, after all.

Keep in mind that in the US there are well over 40,000 zip codes, the last time I looked. Do you need all of them? You might be able to buy what you need. I can't vouch for that site as I've never dealt with them. I'm sure a quick Bing or Google will turn up many similar sites, and of course, you can go directly to the USPS for an official version.

Once you have the data, writing a function to retrieve a state is not difficult.

George

Here is a list of all the states I pulled the list from the post office and created a table.
Michael