the checkbox does not override the hidden element. Either the checkbox is checked and has a value or it is blank and does not have a value.
this is why i suggested using a radio group, this way you have one radio button for "A" and another radio button for "P"
the insert will not loop through the recordset data.
you need a form field for each recordset column set the form field to use the recodset info, and bind the insert to the corresponding form element instead of binding to the rs column.