Results 1 to 3 of 3
  1. #1
    rcarramza is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2019
    Posts
    1

    DlookUp Error

    =DLookUp("LAST_NAME","CUST_INFO","CUST_ID='" & [CustIdCombo])

    LAST_NAME = Column name I am trying to acquire


    CUST_INFO = Table where LAST_NAME IS
    CUST_ID is the first colum of CUST_INFO
    CustIdCombo is the combo box that should have the id I am looking up

    New to Access so I am trying very hard to figure this out. Thank you

  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,518
    You've got a single quote on one side but not the other. Syntax help:

    http://www.theaccessweb.com/general/gen0018.htm
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    This might be an option too:

    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. Dlookup error
    By illes72zoli in forum Access
    Replies: 13
    Last Post: 05-27-2016, 02:41 PM
  2. Replies: 2
    Last Post: 01-04-2016, 09:40 AM
  3. Dlookup error
    By glen.sheppard in forum Access
    Replies: 6
    Last Post: 11-25-2015, 07:30 AM
  4. DLookup error
    By Nadine67 in forum Access
    Replies: 12
    Last Post: 07-14-2015, 02:51 PM
  5. DLookup Error
    By uncletreetrunk in forum Programming
    Replies: 5
    Last Post: 07-16-2012, 08:33 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
  •  
Other Forums: Microsoft Office Forums