Hi there,
I have a set of check box to control a database which means that after i checked the check box and press submit, they will go to next page.
But i have face a problem that is below:

Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'ID =1</TD'.

I don't know why i get this error, maybe i did not doing well coding at the value of the check box. Then below is the code that i use:
------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......

Please help me...i already searching for this answer for a long time already, but i still can not solve it. This system just like the web e-mail system can checked some e-mail and press delete to delete the records. But this is showing those records which are selected.

Thank you.