Hi There,
I have put multiple criteria, three part criteria in a dlookup function from a table using sql. If I use a combination of any two, it works but not all the three. Any reason why? Does dlookup multicriteria limited to two parameters? The Step into shows the required results. Help please. Thanks
strWhereSQL = "[PARCEL] = " & intNum & " AND [PART] = " & intpart & " AND [USER_CODE] ='" & strUserId & "'"
DLookup("id", "tblSearch", strWhereSQL)