Results 1 to 4 of 4
  1. #1
    justgeig is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Dec 2009
    Posts
    45

    Combo box store values in corresponding fields?

    I've setup a table with a complete zip code listing of all US zip codes and their corresponding states and city names. I've added a combo box to a form that looks up these values and allows the user to find the correct city OR zip code and make that selection. What I'd like it to do is give me the option to store field in the zip code table into the corresponding fields of another table i.e. ZipCode to ContactZip, City to ContactCity, etc.



    I have considered using a relationship to just store the ZipCodeID into the Contacts table but the US Postal Service updates their zip code database frequently and I don't want any possibility of a zip code ID changing what zip code it is attached to and ruining my data. Any thoughts on how to accomplish this?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,642
    Like this?

    BaldyWeb - Autofill
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    justgeig is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Dec 2009
    Posts
    45

    Smile

    Quote Originally Posted by pbaldy View Post

    Um yes!! Perfect thanks!

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,642
    Happy to help!
    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. Replies: 5
    Last Post: 03-11-2013, 03:12 PM
  2. How to store values temporarily
    By Naveen Marapaka in forum Programming
    Replies: 8
    Last Post: 12-29-2012, 10:07 AM
  3. Replies: 12
    Last Post: 12-01-2011, 10:28 AM
  4. Hve text combo box values but store integers in field
    By accesshelpasker in forum Access
    Replies: 9
    Last Post: 10-28-2011, 10:49 AM
  5. How do I get dlookup values to store in table
    By rpmyhero in forum Access
    Replies: 1
    Last Post: 11-25-2009, 05:57 AM

Posting Permissions

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