Access Lock/Unlock statement - TechRepublic
General discussion
April 16, 2001 at 03:56 AM
meares

Access Lock/Unlock statement

by meares . Updated 25 years, 2 months ago

I have a form that is used to add/edit employee timesheets. When the record(s) have been verified by the supervisor all the fields are disabled so that the operator can no longer edit the record. (This is done under the on Current Event.) Currently I’m setting in the forms property “Record Locks” to “Edited Records”

What I need to know is how can I unlock a record that the employee is viewing when it shows that it has already been verified by the supervisor. It’s locking the reocord if the employee is in the form and keeping the supervisor from using that record in other update processes.

I would like to be able to under the current event when checking for “if verified” to disable all fields from being edited to also keep the record unlocked.

In advance I thank all of you for taking the time to help out people like me.

This discussion is locked

All Comments