Results 1 to 3 of 3
  1. #1
    cshipley83 is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Aug 2016
    Posts
    28

    DLookup help

    HI.
    I have a Form with a Codes field and a Description field from my Codes table.


    In my Form I want the Description field to auto populate when I enter in my Code field.

    I DO NOT want my Code field to be a Combo Box.

    I was told to enter this DLookup expression in the Code field After Update property.
    Me.Description = DLookup("[Description]", "tblCodes", "Code = " & Me.Code)

    When I do this I get an error message that says it cannot find tblCodes.
    When I delete the tbl part, it will work, but it only populates description from the first record of the Codes table.

    Any input would be greatly appreciated. Thanks.

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    don't double post please you already have a thread open here:

    https://www.accessforums.net/showthread.php?t=61474

  3. #3
    cshipley83 is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Aug 2016
    Posts
    28
    Sorry, i lost it on my screen and couldn't find it again. Thanks.

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

Similar Threads

  1. Shortening if / dlookup >0 / then dlookup
    By Jack Russel in forum Modules
    Replies: 1
    Last Post: 02-19-2016, 03:01 PM
  2. You could use (DLookup) instead of (IIf)
    By azhar2006 in forum Queries
    Replies: 7
    Last Post: 02-11-2014, 12:45 PM
  3. DLookUp
    By Subwind in forum Programming
    Replies: 4
    Last Post: 11-29-2013, 12:39 AM
  4. DLookUp
    By ttam73 in forum Forms
    Replies: 3
    Last Post: 10-18-2013, 12:47 AM
  5. Dlookup
    By Wombat in forum Forms
    Replies: 2
    Last Post: 03-03-2012, 07:21 PM

Tags for this Thread

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