Flash,

This would imply that the checkboxes are *unbound*, i.e. if you look at
their Record Source property it will be blank. Is that what you intend,
or are these checkboxes meant to be linked to fields in the form's
underlying table?

Having said that, 10 Yes/No fields like this means it is also likely
that your table design could be improved. Someone will be able to
advise on this aspect if you can give more details of the data you are
working with, and the meaning of the checkboxes.

--
Steve Schapel, Microsoft Access MVP

Flashjw wrote:
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?