Field access restriction

S

smr

Is there a way to lock all but a few fields on a form for one user and not
lock them for everyone else?
 
J

Jeanette Cunningham

Yes, usually you would have users log in when they start the application.
Save the name and status of the user in your app somewhere either on a
hidden form or in a table. (Assuming each user has their own copy of the
frontend on their workstation).
Then code on the data entry form checks the status of the user when it is
loading.
If the status of the user is the status that allows full access, show the
controls or unlock the controls, otherwise hide or lock the controls.

Jeanette Cunningham
 
Top