auto change yes to no when a date if entered in another field

[Guest]

I am trying to force a status field of yes or no, to show no when an end date
in input into the relevant field

 

[Joseph Meehan]

I am trying to force a status field of yes or no, to show no when an
end date in input into the relevant field

-1 = Yes 0 = No.

 

[Guest]

Run an update query with Is Not Null for the end date field.

 

[SusanV]

In the control where you are entering the date, use the After Update event:

If Nz(me.YourDateField,"") = "" Then
Me.YourYesNoField = 0
Else Me.YourYesNoField = -1
End If

 

[gumby]

Create a Macro

Action = SetValue
Item = [Forms]![Table1]![Ok] ''''''Otherwise '[Forms]![YOUR FORM
NAME]![YOUR FIELD NAME(RELEVANT FIELD)]
Expression = Yes

Save your macro with a name. Assign that macro to your afterupdate
property for your relevant field.