global change within 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

 

[Steve Schapel]

Macamarr,

Probably an Update Query will be the simplest approach.

- Steve Schapel, Microsoft Access MVP