inserting a boolean value into Access table

<i><b>Originally posted by : BalaK (preediti@aol.com)</b></i><br /><br />Can any one tell me how I can pass the value of a checkbox to an asp page and insert the <br />value in a column, whose data type is Yes/No.<br /><br />My input form has<br /><input id=checkbox1 name=ckbxClinical type=checkbox value="yes" checked><br /><br />When I use the Request.Form("ckbxClinical") to update a table, I get <br />ADODB.Recordset error '800a0bb9'<br /><br />I appreciate getting some help on this.

<i><b>Originally posted by : steve</b></i><br />make the value = 1 or 0. if this is a yes no column in the database it will understand that. you can still display yes or no tho,<br /><br /><br />------------<br />BalaK at 3/2/2000 1:58:26 PM<br /><br /><br />Can any one tell me how I can pass the value of a checkbox to an asp page and insert the <br />value in a column, whose data type is Yes/No.<br /><br />My input form has<br /><input id=checkbox1 name=ckbxClinical type=checkbox value="yes" checked><br /><br />When I use the Request.Form("ckbxClinical") to update a table, I get <br />ADODB.Recordset error '800a0bb9'<br /><br />I appreciate getting some help on this.