Results 1 to 2 of 2
  1. #1
    garywmcp is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2011
    Location
    Murrieta, CA
    Posts
    1

    City, State Zip lookup

    I want to be able to fill in the City, State and Zip Code fields in my customer and employee table from my zipcode table.

    I see how I can do a multiple lookup from the zipcode table, however, I don't see how I can use the three columns of data from zipcode table to complete and fill in the same three fields in the customer or employee table.

    As a note, I'm constructing a web data base that will be hosted on a sharepoint hosting site.

    Here are my fields in both tables:

    zipcode table:
    ID
    zip_code
    city
    state_prefix
    county
    locationtext
    location

    customer table:
    first_name
    last_name
    address1
    address2
    city
    state_prefix
    zip_code


    home_phone
    mobile_phone

    Can I use the Lookup & Relationship wizard (I suspect not) or do I need to construct a macro from a query, etc.

    Appreciate the advise

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    20,962
    Does this work for you?

    http://www.baldyweb.com/Autofill.htm
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Selecting the State Code
    By TheBigMaple in forum Queries
    Replies: 1
    Last Post: 03-30-2011, 05:34 PM
  2. Verify state field
    By pwmichaelsr in forum Access
    Replies: 5
    Last Post: 08-16-2010, 12:49 PM
  3. Triple State checkbox scroll order
    By lfox in forum Forms
    Replies: 7
    Last Post: 06-26-2010, 08:19 AM
  4. Pause state?
    By Zermoth in forum Programming
    Replies: 1
    Last Post: 12-15-2008, 05:05 AM
  5. Lookup
    By neon'00 in forum Forms
    Replies: 2
    Last Post: 04-14-2007, 01:19 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums