Hi,
Can some1 tell me what syntax error I generate if I do this :
txtCustName = DLookup("Name", "tblCustomer", "Name like '" & "AB" & "*'" And "Address like '" & "GOLE" & "*'")
It says : Type Mismatch, why? Can I use two criterias in DLookup?
thnx in advance
Skerdi
Can some1 tell me what syntax error I generate if I do this :
txtCustName = DLookup("Name", "tblCustomer", "Name like '" & "AB" & "*'" And "Address like '" & "GOLE" & "*'")
It says : Type Mismatch, why? Can I use two criterias in DLookup?
thnx in advance
Skerdi
