check box applies to all records not just one

R

RachelMillington

I have created an access database form and when I tick a box in one record,
it automatically ticks that box in all records. I dont want it to do this.
How do I change it?
 
R

Rick B

Is this an unbound checkbox? If so, that is how it will work. You must add
a field in your table first, then bind your checkbox to that field.
 
A

Al Camp

Rachel,
Your checkbox is "unbound" to any field in your table, so whatever state
thechecbox is in, applies to all records. Create a field in your table (ex.
MyCheckbox - Tyep = Yes/No - Format = True/False)
On your form, and make the ControlSource of your checkbox MyCheckbox.
Now, because MyCheckbox is a bound field, each record will hold it's own
value.
 
Top