<div>
Both suggestions do the trick and are great, thanks.
</div>


Both suggestions do the trick and are great, thanks.

<div>
<div class="content wysiwyg-content">
Hi,<br />
I have a number of labels on a form and they all have their visible property set to no.<br />
I have given all labels Tag properties depending on which I want visible. So if the user selects &quot;A&quot; from cboRack then all labels with Tag property of &quot;A&quot; will show and all others will not. I am trying to show labels based only on a selection in cboRack.<br />
I have this so far but keep getting an error.<br />
<br />
Dim ctrl As Control<br />
&nbsp; &nbsp; For Each ctrl In Me.Controls<br />
&nbsp; &nbsp; &nbsp; &nbsp; If ctrl.Tag = cboRack Then<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ctrl.Visible = True<br />
&nbsp; &nbsp; &nbsp; &nbsp; Else<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ctrl.Visible = False<br />
&nbsp; &nbsp; &nbsp; &nbsp; End If<br />
&nbsp; &nbsp; Next<br />
<br />
If I take out the else statement it works, but when the user changes the selection in cboRack, the original set of tags are still visible as well as the new selection. I'm trying to hide all labels with tags that are not = to the cboRack selection.<br />
<br />
&quot;Can't hide a control that has the focus&quot;<br />
<br />
Any help is greatly appreciated
</div>
</div>


Hi,
I have a number of labels on a form and they all have their visible property set to no.
I have given all labels Tag properties depending on which I want visible. So if the user selects "A" from cboRack then all labels with Tag property of "A" will show and all others will not. I am trying to show labels based only on a selection in cboRack.
I have this so far but keep getting an error.

Dim ctrl As Control
    For Each ctrl In Me.Controls
        If ctrl.Tag = cboRack Then
            ctrl.Visible = True
        Else
            ctrl.Visible = False
        End If
    Next

If I take out the else statement it works, but when the user changes the selection in cboRack, the original set of tags are still visible as well as the new selection. I'm trying to hide all labels with tags that are not = to the cboRack selection.

"Can't hide a control that has the focus"

Any help is greatly appreciated

hiding controls

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.