Check all check boxes at once

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I have a continious form with each record having a check-
box. I would like to make "Check all" check-box in the
form header which should work as follows: when one checks
it, all the records on the form get checked (something
like "Expand all" hyperlink on "Community Newgroups" web-
page).
 
Mike:
You could run an Update query (SQL) on the AfterUpdate property of
the check=box
This will update the table where the check-boxes come from.

Private Sub MyCheckBox_AfterUpdate()
DoCmd.RunSQL "UPDATE MyTable SET MyTable.CheckBox =
Forms![MyForm]![MyCheckBox]"
End Sub

This will also work if you want to "uncheck" them as well.
Phil

I have a continious form with each record having a check-
box. I would like to make "Check all" check-box in the
form header which should work as follows: when one checks
it, all the records on the form get checked (something
like "Expand all" hyperlink on "Community Newgroups" web-
page).
 
Back
Top