I have a comments field that becomes disabled after a Afterupdate event.
Sometimes users need to go back into the same comments field, so i would like to allow them 1 hour (or something similar) to go back into the same comments field and amend the detail.
Code is similar to the below.
I have a DATE / TIME (tbnow) field that is populated as soon as they start entering comments. As =NOW()..
So can I add to the below code "AND Tbnow > now() -60" or similar ?
If Len(Me.[Assigned Date] & "") > 0 Then
Me.[Assigned Date].Enabled = False
Me.[Assigned Date].Locked = True
Else
Me.[Assigned Date].Enabled = True
Me.[Assigned Date].Locked = False
End If
Sent from my SM-T715 using Tapatalk
Sometimes users need to go back into the same comments field, so i would like to allow them 1 hour (or something similar) to go back into the same comments field and amend the detail.
Code is similar to the below.
I have a DATE / TIME (tbnow) field that is populated as soon as they start entering comments. As =NOW()..
So can I add to the below code "AND Tbnow > now() -60" or similar ?
If Len(Me.[Assigned Date] & "") > 0 Then
Me.[Assigned Date].Enabled = False
Me.[Assigned Date].Locked = True
Else
Me.[Assigned Date].Enabled = True
Me.[Assigned Date].Locked = False
End If
Sent from my SM-T715 using Tapatalk