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.
-
-
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
-StewartLast edited by Stewart Ross; Sep 21 '10, 06:16 PM. -
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!
CheersComment
Comment