Hello,
I try to use the findfirst instruction with multiple criteria.
I use this table where Nr is a autonumberfield and ID and ID2 are numeric fields
The code i wrote :
Dim db As Database
Dim RS As Recordset
Set db = CurrentDb
Set RS = db.OpenRecordset("test", dbOpenDynaset)
Dim strCriteria As String
RS.FindFirst "[ID] =" & 1 And "[ID2] =" & 2
I get an error 'Type mismatch'
Can someone tell me how to fix this?
Thanks in advance.
Anna