Function that locks particular fields - Access 2003
Posted on 2004-04-28
I don't have any knowledge of VBA & would appreciate it if someone could help me out with some code that does the following:
Objective: To protect test results entered & saved via a form from alteration after initial entry... but would like the ability to unlock the field if required.
An associate suggested the following approach:
Have a function that locks required fields. When I save, I would call this function. On the form_OnCurrent event, I would also call this function, so that as you page through each record, the fields remain locked. Also need to have a function that unlocks the fields, if the user is required to edit.