Code to Enter Value into Disabled/Locked Field on Form

gyli84

Registered User.
Local time
Today, 17:00
Joined
Aug 8, 2001
Messages
25
I am creating a helpdesk system and have secured my database with User Level Security and Workgroups and have a script which determines whether the current user is a member of Admin or just a User. If the 'CurrentUser' is not a member of Admin then a checkbox (Assigned User-The member of staff who is assigned the call) on a form called "Calls" where problems are logged is disabled. However is it possible for some code attached to a button to set the currentuser to the person who is logged in despite the fact that the checkbox is disabled (or could this be done if the box is locked to ordinary users rather than disabled) and how would this be coded? I want it so that even though "Users" cannot assign another of member of staff to a call when they log them (as the checkbox-assigned user) is disabled) they can still assign a call to themself.

Within my company there are staff who log calls. They do not necessarily answer the calls themselves though. The calls are recorded in the database and the helpdesk manager assigns the calls according to who he thinks may be best able to solve the problem and thus the Assigned user field is locked to all those but members of Admin. Though this check box is disabled though I would still want it so that a user could press a button to assign the call to themself if say they can solve the problem on the spot or can and will do so later.

Thanks
 
You can still manipulate a table field in code, regardless of whether a control bound to that field is locked in the user interface.
 
I do this all the time.

"Locked" and "Enabled" only refer to the form control, not the data underneath.
 

Users who are viewing this thread

Back
Top Bottom