Open Recordset with selection on two fields

[willkr]

I have an open recordset command that works fine. It is

Set recChkEntry = db.OpenRecordset("Select * From tblChecks Where [Check Number] = " & lngCheckNo)

It works fine unless there are checks with the same check number in two separate accounts. I tried the following:

Set recChkEntry = db.OpenRecordset("Select * From tblChecks Where [Check Number] = " & lngCheckNo & " And [Chk Account] = " & strChkAccount)



This produces a syntax error.

What am I doing wrong?

[Micron]

And that error and its message is??
I'm guessing the account number is a string so it should be [Chk Account] = ' " & strChkAccount & " ' "
I inserted spaces so you can distinguish the quotes, but you wouldn't use them, so

[Chk Account] = '" & strChkAccount & "'"

String and date references need to be delimited (quotes and octothorpes respectively)

[willkr]

Thanks, Micron. That did the trick! I gave you a star.

[Micron]

Glad I could help!
Thanks.