Option Boxes

[Guest]

I have a created a form with several unbound tick boxes. When I move onto a
new record and select different tick boxes it changes the tick boxes in the
previous records. Why is this happening. I need the tick boxes to save.

Your help would be appreciated!

 

[ruralguy via AccessMonster.com]

Unbound tick boxes do not save. I doubt they are changing a previous record,
just not changing when you change records. I suppose you could clear them in
the Current event of the form if you want them to start unchecked for each
record initially.

 

[fredg]

I have a created a form with several unbound tick boxes. When I move onto a
new record and select different tick boxes it changes the tick boxes in the
previous records. Why is this happening. I need the tick boxes to save.

Your help would be appreciated!

That's because the check boxes are unbound. How is Access supposed to
know which record the checked box belongs to?
You need to set the control source of each check box on the form to a
check box field in your table.