display validation message for a locked fields

akika

Registered User.
Local time
Today, 12:19
Joined
Aug 7, 2018
Messages
102
Hi,
In access 2016,
I have a forms with some locked fields.
How can i display a message that when select a value from the drop-down then a msg pop up that "Access denied to amend this field".
 
I don't think you can as they are locked.
As an alternative, perhaps create some small labels marked * next to each control.
Normally these should be hidden but if certain controls are locked make those labels visible. Then have another label on the form stating '*=LOCKED'
 
Why not just set the Enable property to No?
 

Users who are viewing this thread

Back
Top Bottom