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

Change the table design to 9 fields instead of mushing the data into one and no code will be required.

Better still, normalize the table structure to a proper one-to-many relationship using two tables. That way if additional forms are required in the future, no changes need to be made.

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