Visible/Not Visible based on condition VBA

[BLFOSTER]

I have no idea why this has become so difficult. In 2007 it was a snap to make something appear when text was entered in a text box, and make it invisible when text box was empty.



Cannot get this to work - any ideas?

Private Sub Form_Open(Cancel As Integer)


If Not IsNull(Me!Sub1.Form!Sub2withinsub1.Form![sub2field]) Then
Me!Sub1.form.Sub1field.Visible = true
else
Me!Sub1.form.Sub1field.Visible = false
end if

end sub

Thank you!

[pbaldy]

Wrong event for starters, as data isn't usually available in the open event. Try the current event.

[BLFOSTER]

Thank you. I figured it out

[pbaldy]

No problem.