i have a form with multiple checkboxes and i post the data to an add asp page and construct a sql statement. i use if thens to convert the post cb values of "on" and "" to "yes" and "no" [access db by the way] and then build the sql statement. if i put single quotes around the yes and no cb variables i get a data type mismatch error and if i put the cb variables into the sql statement without single quotes i get a too few parameters error. obviously i am missing something, i just cant find an example of this on the web...thanks jg