how do i make a check box control other check boxes?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that has 5 check boxes. I'd like to have an additional check
box that would check all of the other check boxes.

Suggestions? Thanks
 
In the AfterUpdate event of the 6th check box, put code:

Private Sub Checkbox6_AfterUpdate

Me.Checkbox1 = True
Me.Checkbox2 = True
Me.Checkbox3 = True
Me.Checkbox4 = True
Me.Checkbox5 = True

End Sub

Or, if you want all 5 unchecked when checkbox 6 is unchecked,

Private Sub Checkbox6_AfterUpdate

Me.Checkbox1 = Me.Checkbox6
Me.Checkbox2 = Me.Checkbox6
Me.Checkbox3 = Me.Checkbox6
Me.Checkbox4 = Me.Checkbox6
Me.Checkbox5 = Me.Checkbox6

End Sub
 
Back
Top