Hi there,
Now i face a problem that is catch the value of the check box. I can use "Response.Write" method to show them out. But i still can not pass the value and detect the value from the check box. This is because i wanna use them to control some database control. Like passing the selected check box value/records and show into another page.
I always face the error like
"Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'ID =1</TD'.".

My code are below:
------form.asp-------
......a loop coding to loop for the data into this form.....
"<TD><input type=""checkbox"" name=""ID"" id=""ID"" value=" & rsCusts .Fields("ID") & "</TD>" & _
.....coding for the form also.....

------dt.asp------
......above got some coding for checking.....
For i = 1 to Request.Form("ID").Count - 1
strI = Request.Form("ID")(i)
strSOL="SELECT * FROM customer WHERE ID ="& strI
rsCust Open strSOL, objConn <-------ERROR HERE~
......below is the coding that showing data at the page......

So please help or give some me advice about what's going wrong with my code.
Thank you.