Can you please advise on the following.
I have an Audit Form which displays details of audit checks that where carried out on a particular process. On this Audit form the name of the creator of the audit record is displayed along with the name of the person who person who carried out the process exercise.
The form called, 'frmNewAudit' has it's record source bound to a table called 'tblAudit'. Contained in the 'tblAudit' table along with various other fields is the name of the auditor, field name 'Auditor' and processor, field name 'Processor'.
My question is, can you advise how I can trigger a pessimistic record lock so that only the Auditor (the original creator of the record) can edit the record and no one else?
I am aware that this procedure will also require the inclusion of the Public Function fOSUserName function call or something similar.