Dlookup with multiple creteria with Label caption or combo box column

ootkhopdi

Registered User.
Local time
Tomorrow, 04:55
Joined
Oct 17, 2013
Messages
181
Hi

i want to result as dlookup function in access 2007
when i use dlookup like this

=DLookUp("GPFDed","[SalaryAll]","[EMPID]='" & ![Cmb_EMPID] & "' And [SalMonth]='" & "Jan" & "' And [Salyear]='" & [me]![Label17].[Caption] & "'")
it gives #Name?
what is the problem and how can i change the label caption to Combo box column 2 value

pls give me solution
 
Well, it would give an error because you can't use me outside VBA. Try the full form reference first.
 

Users who are viewing this thread

Back
Top Bottom