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?