outside it said no question's too easy to ask so here goes. I've been trying for the last 15-16 hours to come up with a way to store the state of a checkbox in a Yes/No MS Access field; and you guessed it. it doesn work.<BR>So I stripped down my huge form to only one checkbox field. And still all I get is : Data type mismatch in criteria expression. I'm about to throw this laptop out of the window so any help at all would be appreciated.<BR>Here 's the code that's doing all the work (actually doesnt..) if you need to check it.<BR>the FORM:<BR><form action="testaddcheckbox.asp" method="post"><BR><table border="0" width="756"><BR> <tr class="smlitgr"><BR> 4WD:<input type="checkbox" NAME="testbox"></td><BR><tr class="smdrkgr"><BR><td><BR><i nput type="submit" value="Register"><BR></td><BR></tr><BR></table><BR></form><BR><BR>and here's the testaddcheckbox.asp which was supposed to add the value to the Yes/No field of Access:<BR><BR><%<BR>car_4wd = Request.Form("car_4wd")<BR><BR>IF testbox = "on" THEN<BR>testbox = "YES"<BR>END IF<BR><BR>Set Conn = Server.CreateObject("ADODB.Connection")<BR>Conn.Op en "accessDSN"<BR>%><BR><html><BR> 0;head><BR><title></title><BR></head><BR><body><BR><% <BR>sqlString = "INSERT INTO test1 (check) VALUES ('"&testbox&"')"<BR><BR>Conn.Execute sqlString<BR>%><BR><BR>where of course test1 is the table, check is the Yes/No field.<BR>The "check" field by the way, I tried to play around with all forms of values it could take in Access. Yes/No, True/False and 1/0. Still nothing...<BR>Any ideas how to put that little tick in there?