How to Iterate through all Controls with a Particular Tag

[sueb]

On a subform, I want to change Properties for a set for fields. All these fields have the same Tag, and when I click a button on the form, I want to interate through these fields and set their Visibility.

What's the syntax for addressing these fields? Sort of like:

for each field_on_the_form.tag = "whatever" do
     field.visibility = true
end for

[Jerry Maiapu]

One question. Is the subform in datasheet or continous or form view.?
I don know if it is possible in datasheet but it could be acheived in the other two views.

[sueb]

Oh, yes, it's continuous. I realize this means that all instances will change at once, but that's okay.

[Jerry Maiapu]

Try this:

Create the cmd button on the subform and add the following to its on_click event.

Dim ctl As Control
For Each ctl In Me.Controls
    If ctl.Tag = “Input your tag value here” Then
Ctl.Visible=True
    End If
Next ctl

Hope this helps...

Passing by

[sueb]

Oh, thanks, Jerry! That's just what I needed!

[ADezii]

Dim ctl As Control
 
For Each ctl In Me.Controls
  ctl.Visible = (ctl.Tag = "Input your tag value here")
Next