Is there a way to lock records that were logged “in the past”? In other words, once a new day is upon us, the previous records that are now in the past, are locked and unable to be modified/changed/edited. I need the table to be able to have the add and change with the delete turned off. But I’m looking for a “lock-out” feature.
You can update the system-generated Edit action for that source table to only allow edits for rows with an entry date of TODAY.
You would do this by opening the action, expanding the Behavior section and adding to the “Only if this is condition is true” property an expression like this:
[Entered Date] = TODAY()
Where [Entered Date] is updated to your specific column name.
Yes sir John…thank you.