dbSeeChanges Error

[Moonshine]

Hi All

Im using an access front end to add/amend/get data from SQL Server tables, when opening recordsets you need to use the dbSeeChanges as an option, which i am doing, and for Adds/Edits it works fine, however, when im trying to Get data, i get an error telling me "Data Type MisMatch".

So i ponder this for a while, and then do a debug.print on the OpenRecordSet code, which then shows me the problem

This Is The OpenRecordSet

Set rstFind = CurrentDb.OpenRecordset("select * from [eaEquipmentDetails] where eaEquipmentID = " & Me.List1, dbOpenDynaset, dbSeeChanges)

What id expect to get is this:

select * from [eaEquipmentDetails] where eaEquipmentID = 4012

However, what im getting is:

select * from [eaEquipmentDetails] where eaEquipmentID = 4012                3                    512

It seems the two options of the recordsetopen, has a numeric value, so the query fails. How can i get it to ingnore the last two opens, and stop putting the values in the query?!