Hide Fields on Tabe Control

[mizenerman]

Hello all. What I'm trying to do is simple and I've read through various threads in this forum and found bits and pieces of what I need but still having an issue. The issue is:

I'm attempting to make bound controls visible/not visible on a tab control. The problem is that on the first record the code works as desired. However, when I move to the second record the same fields visible on the first record are visible on the second - not desired.

I'm trying to give the user an option when they select a Y/N text box. If the text box is selected to Y then certain controls are visible. If the text box is N then those fields should not be visible.

The code:
Private Sub AddMore5_AfterUpdate()
If [AddMore5] = "Y" Then
Radiology_Date6Label.Visible = True
Radiology_Study6Label.Visible = True
Radiology_Comments6Label.Visible = True
Radiology_Date6.Visible = True
Radiology_Study6.Visible = True
Radiology_Comments6.Visible = True
AddMore6_Label.Visible = True
AddMore6.Visible = True
Else
Radiology_Date6Label.Visible = False
Radiology_Study6Label.Visible = False
Radiology_Comments6Label.Visible = False
Radiology_Date6.Visible = False
Radiology_Study6.Visible = False
Radiology_Comments6.Visible = False
AddMore6_Label.Visible = False
AddMore6.Visible = False
End If
End Sub

I've tried this in the Change event with not avail. Any suggestions are much appreciated.

Thank you.

 

[VRoscioli]

Add the code (or a reference to the subroutine) to the Form's Current event. This should update it when changing from one record to another.


-V

 

[mizenerman]

Thanks VRoscioli. I tried that but still getting the same result. I checked and there is not other Event being fired on the form other than this. What am I missing?

 

[VRoscioli]

Is the Y/N checkbox bound to a field? If not, you'll need to set that to whatever default value you want in the Form's Current event.


-V

 

[mizenerman]

The Y/N is unbound and I put the default in as you suggested and it had the same result. HOWEVER, I made the field bound and now it works like a charm. I don't necessarily want a bound field but it won't kill me either. Thanks V for talking it out with me!