Results 1 to 2 of 2
  1. #1
    rpmyhero is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2009
    Posts
    2

    How do I get dlookup values to store in table

    I am using Access 2003. I created 2 tables a BusLic Table and a TaxReturn table. I created a form for the BusLic data entry and I used a dlookup function to lookup zipcodes, city and state in a zipcodes database i downloaded. When i enter the zipcode for any business license the form automatically fills in the city and state fields.(Works great!). Makes things alot easier.I then created a Tax Return form which i used the dlookup to lookup the business name and address from the BusLic table (It works). However, when i try to dlookup the city and state it does not work. In reviewing the dlookup statement i went and checked the BusLic table to see if the city's that were retrieved by the dlookup in the BusLic form were there but they werent. Is it because when data is retrieved into a field through a dlookup they are not stored as data and it is only the data that is actually entered (typed in) that is stored vs dlookup values? Is there a way to have access store the dlookup values in the the appropiate fields in the BusLic table? Otherwise, if i decide to use the BusLic table for other forms or queries the information wouldn't be there to retrieve, therefore, i would have to type in each city and state and not use the dlookup for zipcodes which was the purpose of having it automatically fill in the appropriate city and state. I hope and pray you have an answer

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    If you create a query thet joins the BusLic table with your ZipCode table on the ZipCode field and include the City and State fields from the ZipCode table, then every time you change the ZipCode the City and State will automatically change with it.

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

Similar Threads

  1. Pizza store database help!
    By zagorette in forum Database Design
    Replies: 2
    Last Post: 06-30-2009, 10:47 AM
  2. Possible to store user-defined types in table?
    By Binky in forum Programming
    Replies: 0
    Last Post: 11-20-2008, 02:28 PM
  3. Table values in forms
    By xzxz in forum Access
    Replies: 3
    Last Post: 10-28-2008, 08:29 AM
  4. How to query boolean values from table
    By kevdmiller in forum Queries
    Replies: 2
    Last Post: 11-30-2006, 07:41 PM
  5. Replies: 0
    Last Post: 09-25-2006, 03:42 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