Asp updating access check box

However, nothing gets updated now (where the other 4 fields were OK earlier).

Form("frm Register") & "', '" I get the error message that there is a string error. abf = "INSERT INTO [registration] ( register, newusername, email, newpassword ) VALUES " & "('" & Request.But then I get the error message that there is a criteria mismatch.If I change the insert line from: abf = abf & Server.In the mean time, I have recreated the Yes/No field to be a Text Field which stores "Yes" or "No", and the checkboxes update correctly in both display mode and when I go into Edit mode. Using the Ole Db Command, if I do not consider the Yes/No field, the Execute Non Query command, using my UPDATE SQL statement, updates the record correctly.However, nothing gets updated now (where the other 4 fields were OK earlier). However, if I put the Yes/No field into the mix, Execute Non Query returns 0 (0 records updated).