I'm getting an error 3061:
Too Few parameters. Expected 3.
This is the code I'm trying to use:
k = rsTemp2!custno
ChkNo = rsTemp2!checknumber
Set rsQry2 = db.OpenRecordset("Select * from transactions " _
& "WHERE (((tranactions.[custno])= " & k & " AND " _
& "tranactions.[check number] = '" & ChkNo & "')) ORDER BY tranactions.date DESC;")