Data type mismatch 1

[jelsberry]

I am doing a FindFirst on a dynaset recordset, i get a data type mismatch in criteria expression error, my findfirst statement is as follows:
.FindFirst "[ID] =" & "'" & SessionId & "'"
Where ID is a autonumber and sessionid is a integer, i have also tried sessionid as a long, both give me a mismatch error. Any help would be appreciated.

Thanks

 

[JimHorton]

Remove the extra quotes:
FindFirst "[ID] =" & SessionId
--Jim