See code below.
This was a very helpful response I got to an earlier query.
It prevents the user from changing data unless it is a new record.
Unfortunately, it is also preventing the user from filtering and or sorting this data.
Is it possible to prevent change but allow filter (preferably by using something similar to the code below?
Me.YourControl.Enabled = Me.NewRecord
Me.YourControl.Locked = Not Me.NewRecord