Type Mismatch in DLookup with multiple criteria

[adibakale]

I am receiving a Type Mismatch error and cannot figure out why. I had a Dlookup with 1 criteria, which was working fine. I have been trying to 2 additional criteria which come from the same table to this dlookup, however I keep getting a type mismatch error.
Here is my code:

M_ID = DLookup("Id", "tbl_Merchant", "[MERCHANT NAME] = '" & mer & "'" And "[MERCHANT city] = '" & mer_city & "'" And "[MERCHANT COUNTRY] = '" & mer_country & "'")

Any help with this is greatly appreciated.

 

[Micron]

Try M_ID = DLookup("Id", "tbl_Merchant", "[MERCHANT NAME] = '" & mer & "' And [MERCHANT city] = '" & mer_city & "' And [MERCHANT COUNTRY] = '" & mer_country & "'")

It looks like your And operators are not enclosed in quotes. This "'" ends the string part that is enclosed, then you follow it with And, which is not enclosed.