I'm still having trouble posting follow-ups. :-(
"Unable to retrieve message
7cc66112.0501041919.3a6628b4 (AT) po...OT) google.com"
Now Turtle wrote "You'll need an extra field in the table underlying
the subform." ....................hmmmmmmmmm...................
I put in a field in the underlying table with a default value of 1.
I created a text box which adds up the values in the new field
-(txtRecordCounter).
I created another text box which adds up the absolute total value of
the checkboxes - ( txtTotCheck).
Reference these from the main form and if
txtRecordCounter=txtTotCheck, all the checkboxes in the subform are
ticked.
This seems to work well.
Karl
Thanks Turtle, but ... what for ? Could you please explain a little
more.
I am wanting to know the status of all check boxes in a continuous
form ie. all are 'ticked'.
MacDermott wrote -
You'll need an extra field in the table underlying the subform.
"Karl Roes" <karlroes (AT) hotmail (DOT) com> wrote
Quote:
Hi all,
Is it possible to check the status of the check box on every record in
a continuous subform ( one check box per record ).
I am wanting to check the " Approved " status of all subform records
in the Before_Update event of a main form combo.
Thanks and regards
Karl. |