checkbox - how do I stop it infulencing all other data records

[Guest]

After adding a checkbox to my form in design view (from toolbox), I find that
when I 'tick that box' for one particular record it 'ticks the same box' for
all my other records. This is easy to demonstrate in datasheet view. How do
I stop this happening so that each record can have an independent answer?

Thanks

 

[Guest]

Hi Louise

The check box is unbound

You need to add a field to the table that the form is based on - format this
new field as Yes/No. Then open the form in design view and open the
properties box for the check box. Use the new field and the source for the
box. This will allow each record to hold independant data (ie. Yes or No -
True or False - etc)

 

[Rick B]

The box needs to be bound to a field in your table. If you want record #1
to be "yes" and record #2 to be "no" then you have to store that in your
table with the record.