Can someone point out where I am going wrong below? I am trying to change the value of one field based on another field having a any value.
Private Sub ClosedDate_Exit(Cancel As Integer)
If Me!ClosedDate.Value = Not Null Then
Me!CurrentlyWith.Value = "CLOSED"
ElseIf Me!ClosedDate.Value Is Null Then
Me!CurrentlyWith.Value = " "
End If
End Sub
Private Sub ClosedDate_Exit(Cancel As Integer)
If Me!ClosedDate.Value = Not Null Then
Me!CurrentlyWith.Value = "CLOSED"
ElseIf Me!ClosedDate.Value Is Null Then
Me!CurrentlyWith.Value = " "
End If
End Sub