Confused by 'Tag'

[rbinder]

Greetings all,

I have done a bit of reading and research on the 'tag' property in forms and tried to set some code. Now I am all muddled as to how to do it and what comes first?

What I am trying to do is if the condition in one field 'time required' is yes then I would like a whole lot of bound controls (fields) not to appear so that the user cannot enter any information by mistake.

The code is below;

Dim ctl As Control

For Each ctl In Me.Controls

If Me.TimeRequired.Value = "-1" Then
If Me.Tag = "Fermyesno" Then

ctl.Visible = False
End If
End If


Set ctl = Nothing

Can someone set me straight.

rbinder

 

[jrjr]

I'll give it a go

What is the TimeRequired control, a check box, combo, ??

If it is a check box then this should work in the after update event:

If Me.TimeRequired = Yes Then
ctl.Visible = False
End If

My point is to use the correct value. Perhaps -1 is not correct in your usage