check box applies to all records not just one

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.


--
Rick B



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

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.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

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