display validation message for a locked fields (1 Viewer)

akika

Registered User.
Local time
Yesterday, 18:44
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".
 

isladogs

MVP / VIP
Local time
Today, 01:44
Joined
Jan 14, 2017
Messages
18,186
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'
 

JHB

Have been here a while
Local time
Today, 02:44
Joined
Jun 17, 2012
Messages
7,732
Why not just set the Enable property to No?
 

Users who are viewing this thread

Top Bottom