I have just created my first Access database and form. I have a problem with
the check boxes. When I am in record #1 and check the applicable box, it
stays checked in all the other records. So when I change the check box to the
applicable one for record 2, that becomes checked in all records.

How do I format my checkboxes (I have 10 of them) so that checking them in
record 1 only checks them in record 1, instead of checking them in all of the
records?

I have 10 check boxes, and in some records, as many as 8 of them need to be
checked; in some records, only 1 needs to be checked. Is there a better way
to do this other than check boxes?