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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Lesley" <(E-Mail Removed)> wrote in message
news:61F73653-7358-4036-AABD-(E-Mail Removed)...
>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