Dlookup with two criteria syntax help

[latex88]

Hi,

I'm having a hard time figuring out the exact syntax for the below dlookup function. When I separate the criteria individually, I get a result, but when I combine the two, I get run-time error of Type Mismatch.

strTableID is a string variable

DLookup("ID", "MyTable", "myFieldName= '" & strTableID & "'" And "Status = 'Open' ")

 

[jdraw]

Try this one:

DLookup("ID", "MyTable", "myFieldName= '" & strTableID & "' And Status = 'Open' ")

 

[latex88]

That worked great. Thanks.