View Single Post
  #2  
Old April 25th, 2008, 10:00 PM posted to microsoft.public.access.forms
Dirk Goldgar
external usenet poster
 
Posts: 2,529
Default Questions check boxes from new Access user

"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)