Trying to hide value in a form field until another field = "Y"

I have 2 fields on a form.  The first one is a value list field and the choices are either "Y" or "N".

The second field is a calculated field being calculated in the query which the form is using as its record source.

But I want the value in the second field to be hidden until the value in the 1st field = "Y" and I can't seem to make it happen that way.  The value in the second field displays no matter what.

--Steve
SteveL13Asked:
Who is Participating?
 
IrogSintaConnect With a Mentor Commented:
In the AfterUpdate event of the List Control add something like this:
Me.NameOfCalculatedControl.Visible = (Me.NameOfListControl = "Y")

Open in new window

Then in the OnCurrent event of the form call the AfterUpdate event of your list control:
Call NameOfListControl_AfterUpdate

Ron
0
 
clarkscottCommented:
I was going to suggest another way... but Ron's is perfect.

Scott C
0
All Courses

From novice to tech pro — start learning today.