I have tried to do that but I guess I'm doing something wrong, because now I
can't even check the boxes - they are grayed out on the form and won't check.
Can you give me step by step instructions? I'm not altogether sure I
successfully created a Yes/No field (I think I did) and I am more sure that
the problem is that I did not bind the check box to the field correctly.

Any step by step help would be greatly appreciated! Thank you so much!

"Dirk Goldgar" wrote:

"Flashjw" wrote in message
...
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?


From the sound of it, your check boxes aren't bound to any field in the
table. If you want to store the state of a check box for a particular
record, you must have a Yes/No field in the form's underlying table (the
form's RecordSource) to hold that state, and you must bind your check box to
it by setting the check box control's Control Source property to the name of
that field.

Any control that is unbound -- that is, with a blank Control Source -- will
have the same value for all records on your form. It's the ControlSource
that binds the control to a particular field in the form's current record.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)