Data type mismatch in criteria expression

i can tell by this thread exactly what the second problem

Gullian posted the correct code:
strSQL = "SELECT firstname FROM tblUsers WHERE ID ='" & userID & "'"
(which btw is trying to compare the integer field "ID" to the string "userID", hence the data doesn't match in type, hence the "data mismatch" error)
To
strSQL = "SELECT firstname FROM tblUsers WHERE ID =" & userID

twooly just went and hacked off the last concatination of the string, so he went from:
strSQL = "SELECT firstname FROM tblUsers WHERE ID ='" & userID & "'"
To
strSQL = "SELECT firstname FROM tblUsers WHERE ID ='" & userID

notice the bold tic mark still left, so when he went to run the page, ADO saw:
SELECT firstname FROM tblUsers WHERE ID ='1

and coughed up the proverbial hairball......

classic case of "tell me how to fix it" without understanding why it broke