Check Boxes

[thrust]

I want to select or deselect with one click all check boxes in a group of them that i will decide in a form of access 2007.
I welcome any suggestion.

 

[RuralGuy]

Use the Tag property to group the CheckBoxes and then walk the Controls Collection to check/uncheck them.

 

[thrust]

What is the Controls Collection? And how do i group the checkboxes with the Tag property? I guess it doesn't need to use code because i don't know nothing about it.

Heelp!

 

[RuralGuy]

See if post #2 in this thread helps: http://www.access-programmers.co.uk/forums/showthread.php?t=161934

 

[RuralGuy]

What scheme were you going to use to "group" these CheckBoxes?

 

[thrust]

How am i going to "group" the checkboxes?

 

[RuralGuy]

Your 1st post talks about a "group of them". Will it be all of the CheckBoxes on the form or a subset of all of them? Are you going to give them similar names or what?

 

[thrust]

I want to create three groups of all the CheckBoxes i have in a form and check or uncheck the CheckBoxes of every group with just one click.

 

[RuralGuy]

Since you are not unchecking them by group then the following should work:

Private Sub cmdClear_Click()
   Dim ctl As Control
   For Each ctl In Me.Controls
      If ctl.ControlType = acCheckBox Then
         ctl.Value = False
      End If
   Next ctl
End Sub