unbound checkbox in datasheet subforms - select one it selects all (do not want!)

[AccessIdiot]

Title says it all - I have a form with a subform. Subform has one unbound checkbox whose sole purpose is to launch another form when checked. I have this subform in datasheet view (for ease of data entry). When I check one checkbox it checks them all. How do I prevent this? I don't have the same problem with a different checkbox that is bound to a field in the table.

[Stewart Ross]

There is only one instance of the control concerned on a subform, repeated many times for the rows displayed. When unbound, that single instance changes simultaneously on all rows. You simply cannot use an unbound control the way you are hoping to.

Short answer is to take that control off the subform's detail section and place it in the header or footer, or put something that isn't a checkbox in its place - like a small picture with an on-click event. Unfortunately, you can't do this in datasheet view - needs to be a continuous form view instead.

We have an article touching on this issue in our insights section:

Why values in unbound form controls don't persist

-Stewart

[AccessIdiot]

Thanks Stewart, I guess it's good to know that I wasn't stupidly missing something simple. Although it also would have been great if it were!

Cheers