Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2005
    Posts
    7

    Unanswered: Zip Code Lookup?

    I am a Noobe . I would like to know the best way to set up an auto lookup for city, state, and county by entering the zip code into a form.

    The form allows my users to enter customer information like name, address, and phone number. To save my users time, I would like for them to just enter the zip code into the form, and then the form would automatically enter the city, state, and county. I have the information for the zip codes. I just do not know the best way to implement this. Any help would be appreciated.

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    zip code would basically be the primary key in a lookup table. Nothing to tricky.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    You should probably think about how to deal with zip codes that contain more than one city/county/state. Normally folks will go with the USPS preferred usage, but sometimes the users insist on being allowed to deal with any of the valid combinations for a given zip code.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •