Results 1 to 2 of 2
  1. 02-17-2022, 09:22 AM #1
    chrisdd
    chrisdd is offline Novice
    Windows 10 Office 365
    Join Date
    Mar 2020
    Posts
    13

    Dlookup

    Can anyone help me out with why this isn't working



    Code:
    connotemp = DLookup("CollectionRef", "Waste_collections", "[CustomerID]=" & tcompanyid And "[ConsignmentNoteNumber] = '" & Me.conno & "'")

    CustomerID is an number and conno is a string

    Thanks!
    Reply With Quote Reply With Quote
  2. 02-17-2022, 09:31 AM #2
    ranman256's Avatar
    ranman256
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    your quotes are a little off...


    = DLookup("CollectionRef", "Waste_collections", "[CustomerID]=" & tcompanyid & " And [ConsignmentNoteNumber] = '" & Me.conno & "'")
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Access Dlookup of a Dlookup Assistance
    By caper in forum Access
    Replies: 3
    Last Post: 08-27-2020, 05:56 PM
  2. Dlookup
    By dgarber in forum Access
    Replies: 5
    Last Post: 12-02-2017, 02:37 PM
  3. Help with Dlookup
    By pmangan in forum Access
    Replies: 18
    Last Post: 11-14-2017, 10:46 AM
  4. Shortening if / dlookup >0 / then dlookup
    By Jack Russel in forum Modules
    Replies: 1
    Last Post: 02-19-2016, 03:01 PM
  5. May it is Dlookup
    By cap.zadi in forum Programming
    Replies: 3
    Last Post: 05-09-2011, 05:58 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums