Control Exclusive to Record

I've been working with a database and I recently added a Check Box that I
want to be exclusive to each record. However, when I click the Check Box for
ONE record, all of the records automatically get checked as well. Is there a
way that I can make sure that the when I click the Check Box that the
information is exclusive to the one record?

Create a yes/no field in your table.
Set the Control Source of your check box to this field.

Since it is bound to a field in the table, it can now have a different value
for each record.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Tania" wrote in message
...
I've been working with a database and I recently added a Check Box that I
want to be exclusive to each record. However, when I click the Check Box
for
ONE record, all of the records automatically get checked as well. Is
there a
way that I can make sure that the when I click the Check Box that the
information is exclusive to the one record?