Data type mismatch in criteria expression.

[dheema]

SQL2 = "SELECT Firstname,Surname FROM tblMembers where ID='"&rg i have change this code to the following oneSQL2 = "SELECT Firstname,Surname FROM tblMembers where ID='"&rg&"'" but am still an error message for this line:**Data type mismatch in criteria expression.**set RS = objConn.Execute (SQL2) please help

[Shog9 0]

So, what forum did you think this was again?

----

It appears that everybody is under the impression that I approve of the documentation. You probably also blame Ken Burns for supporting slavery.

--Raymond Chen on MSDN