How to clear all checkboxes on a form?
 

That's it. How is it possible to create push-button functionality that
resets all checkboxes to empty?

Also, is it possible that pushing a button could increase a counter, or
light up a first, second and third cell, that would then be reset by the
button I asked for above?

I thank you for your time.

Arlen

How to clear all checkboxes on a form?
 

For Each ctl In Me.Controls

If TypeName(ctl) = "CheckBox" Then

ctl.Value = False
End I
Next ctl

--

HTH

Bob

"Arlen" wrote in message
...
That's it. How is it possible to create push-button functionality that
resets all checkboxes to empty?

Also, is it possible that pushing a button could increase a counter, or
light up a first, second and third cell, that would then be reset by the
button I asked for above?

I thank you for your time.

Arlen

How to clear all checkboxes on a form?
 

Thanks, Bob!

"Bob Phillips" wrote:

For Each ctl In Me.Controls

If TypeName(ctl) = "CheckBox" Then

ctl.Value = False
End I
Next ctl

--

HTH

Bob

"Arlen" wrote in message
...
That's it. How is it possible to create push-button functionality that
resets all checkboxes to empty?

Also, is it possible that pushing a button could increase a counter, or
light up a first, second and third cell, that would then be reset by the
button I asked for above?

I thank you for your time.

Arlen


.