global change on form

[macamarr]

Hello,
My form has 10 records and what I am attempting to do is
make a global change using a button or what ever it takes
to make this work. Below is the code I use to clear all
checkboxes on the form. My problem is that I have to do
this for each record. Is there a way I can do this with
one click for every record on the form? Thanks!

Private Sub cmdClear_Click()
S.Value = False
M.Value = False
T.Value = False
W.Value = False
R.Value = False
F.Value = False
Sa.Value = False
End Sub

 

[Mudface]

You can use code like this. The second sub event allows you to toggle all the checkboxes on and off, which might also be useful:-

Private Sub cmdClear_Click()
Dim ctl As Control

For Each ctl In Me.Controls
    If TypeOf ctl Is CheckBox Then
        ctl.Value = False
    End If
Next ctl

End Sub

Private Sub cmdToggle_Click()
Dim ctl As Control

For Each ctl In Me.Controls
    If TypeOf ctl Is CheckBox Then
        ctl.Value = Not ctl.Value
    End If
Next ctl

End Sub