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.