Using tags instead of AND

[rikklaney1]

I have a form with 10 yes/no controls. The value of the 10th will be yes IF the value of all the other 9 is yes else 10 will be no. My question is can I use tags, or some other method, to look at all the controls rather than create an if statement calling out all nine controls with and? Is there a better way?

 

[pbaldy]

Sure:

  Dim ctl As Control

  For Each ctl In Me.Controls   
    If ctl.Tag = "whatever" Then
      'Do something
    End If
  Next ctl

 

[rikklaney1]

That did it Uncle Gizmo. Thanks.

 

[rikklaney1]

That did it Uncle Gizmo. Thanks. That intcounter was what I was missing.