Please help, option group checkboxes

[Dgavilanes]

Need to Upddate a single field in a table named "Status" from 9 separate option groups, each containing two values yes=1, No=2.
This is use on a fly, in a data entry form where user selects documents received in the
mail.
Ex: Transcripts yes no
Medical yes no
resume yes no
etc
Any hepl will be greatly appreciated
dennis

 

[Dgavilanes]

I'm using two tables, one to many relationship, because I have 9 separate Group option boxes(two options each), having the same rowsource(Status)on all everytime I select an option all responde the same,like copies of each other. Need to create some code that tells the group option selected to go to the next record (auto number)and update the field, by using a single field in a continous form,isn't that good normalizing procedure?
can it be done
Dennis