Dlookup not working (1 Viewer)

D

Djblois

Registered User.
Local time
Yesterday, 21:22
Joined
Jan 26, 2009
Messages
598
I am trying to use this dlookup as my Control Source for a textbox:

Code: 
DLookUp("Customer","tblCustomer","Customer_ID = " & [Forms]![frmSellingMain]![tbCustID])

I cannot figure out why it is not working. The syntax looks correct and I checked the spelling over and over.
 
SOS

SOS

Registered Lunatic
Local time
Yesterday, 21:22
Joined
Aug 27, 2008
Messages
3,517
If CustomerID is a text value you would need:

=DLookUp("Customer","tblCustomer","Customer_ID = " & Chr(34) & [Forms]![frmSellingMain]![tbCustID] & Chr(34))

and make sure the equals sign is there.
 
You must log in or register to reply here.

Similar threads

S
Default Values
Replies
5
Views
234
Pat Hartman
P
C
Dlookup error
Replies
7
Views
617
Gasman
Gasman
C
Solved Combine both IIf and DLookup as Form control Source
Replies
2
Views
401
captbluefin
C
E
Issue with Dlookup- Help Please!
2
Replies
20
Views
466
June7
June7
E
Solved Listbox search not working with aggregated query
Replies
7
Views
259
elannesse
E

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Top Bottom