Control Exclusive to Record

[Tania]

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?

 

[Allen Browne]

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.