check box applies to all records not just one

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
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.
 
Back
Top