Hey guys,
I researched around to try and find out how to do this, but I coudln't find anywhere, and I just started using VBA.
Anyways, I'm making a form for a database for patients, and I made 3 controls: Biopsy Date 1, Biopsy Date 2, and Biopsy Date 3. I'm making the form so that the entire hospital staff can enter data into it, and I wanted to make it look more streamlined (impress the boss...) and make is so that Biopsy Date 2 and Biopsy Date 3 didn't show up if Biopsy Date 1 was a null value.
Here's the code I have so far, but it's not working... (I'm just trying to get 2 to be hidden... Once I get this down, I'm sure adding Biopsy Date 3 will be a piece of cake).
Thanks for your help!Option Compare Database Public Sub Biopsy_Multi_Hide() If Nz(Me![Biopsy Date #1], [ValueIfNull]) = [] Then Me![Biopsy Date #2].Visible = False Else Me![Biopsy Date #2].Visible = True End Sub