Changing visiblity of field based on another. Code not working

[ChuckJ]

I have a Form with Tabs inside it. On one page I would like one field to not be visible if another field has "Yes" in it. However, I can not get the code to work. I inserted this code into VB and then changed from Design view to Form view and it doesnt appear to work. I looked around on the net and many say to use OnCurrent, but I dont even have that option so I went with BeforeUpdate

Private Sub R9790_SN_BeforeUpdate(Cancel As Integer)
If Me.Fld9790 = "Yes" Then
Me.R9790_SN.Visible = True
Me.SD.Visible = False
Else
Me.R9790_SN.Visible = False
Me.SD.Visible = True
End If


End Sub

[ChuckJ]

Disregard. I forget OnCurrent is available in Form properties. Code is working now

[ranman256]

It would only need to be:

R9790_SN.Visible = Fld9790 = "Yes"
SD.Visible = Fld9790 = "No"