Hello, please I need help on this, is there any way to update a yes/no field when a number in another field change?
For example, I have a table with a 4 fields, 2 are Field Dates, another is the difference of this to date that could be negative or positive, and the other field is name EXPIRED(yes/No), that I want is when the difference in 3 field is negative the field is YES, and when is positive is NO in the EXPIRED field, I get the change but just in afterupdate, but I need this automatic when the number change
Private Sub Expired_BeforeUpdate(Cancel As Integer)
If Me.Days_Ramaining.Value < 0 Then
Me.[Expired] = True
End If
Else
If Me.Days_Ramaining.Value > 0 Then
Me.[Expired] = False
End If
End Sub
THanks