Good morning!
I'm using the below code. It works great, with the exception, if the record is today's date, it's locking it.
I think it has something to do with the way I wrote the condition for checking the date. It's not seeing the +1 for the date.
I want them to be able to update the record, until the Me.End_Date is later than today's date +1.
Thoughts on my error? I can adjust the record if End_Date is tomorrow, but not today's date. Thank you!
Private Sub Form_Current()
If Me.End_Date > Date + 1 Then
Me.Toggle37.Locked = True
Me.Toggle38.Locked = True
Me.Toggle39.Locked = True
Me.Score.Locked = True
Else: Me.Toggle37.Locked = False
Me.Toggle38.Locked = False
Me.Toggle39.Locked = False
Me.Score.Locked = False
End If
End Sub