Hi
I have written a code for a field to become visible (it's set to invisible in the properties of the field) if it meets a certain requirement:
Private Sub Domain_AfterUpdate()
If Domain = "Partnerships for Systems Change and Policy Development" Then
Partners_Label.Visible = True
Partners.Visible = True
ElseIf Domain = "" Then
Activity_Label.Visible = False
Partners.Visible = False
End If
End Sub
Everything works but if the field is visible it stays on the screen when I go to the next record. How do I get it to go back to being invisible when I go to the next record?
I have written a code for a field to become visible (it's set to invisible in the properties of the field) if it meets a certain requirement:
Private Sub Domain_AfterUpdate()
If Domain = "Partnerships for Systems Change and Policy Development" Then
Partners_Label.Visible = True
Partners.Visible = True
ElseIf Domain = "" Then
Activity_Label.Visible = False
Partners.Visible = False
End If
End Sub
Everything works but if the field is visible it stays on the screen when I go to the next record. How do I get it to go back to being invisible when I go to the next record?