Hello,
Can someone please help me to correct the codes below as always ended up error:
Private Sub Date_AfterUpdate()
If Me.Date = "IS NULL" Then Me.Completed = "No"
Else
If Me.Date = "IS NOT NULL" Then Me.Completed = "Yes"
End Sub
The intention of the code is to have an automation value for "Yes and No" whenever the Date field is changed.
If the date field has value then it should be Yes and if null it should be "NO".
Can someone please help me to correct the codes below as always ended up error:
Private Sub Date_AfterUpdate()
If Me.Date = "IS NULL" Then Me.Completed = "No"
Else
If Me.Date = "IS NOT NULL" Then Me.Completed = "Yes"
End Sub
The intention of the code is to have an automation value for "Yes and No" whenever the Date field is changed.
If the date field has value then it should be Yes and if null it should be "NO".