At the moment I have the following code on the OnCurrent Event of a datasheet.
Which essentially locks the record so it wont appear in a query list whislt someone is in the record.
What I want to do is move it back to "Free" when they move to another record. However, this would conflict with the above code.
Is there a better way to lock the record that the user has selected so no one else can make changes to it?
Code:
Forms!frmLeads!frmLeadsSubForm.Form!TempAdviserLock = "Locked"Which essentially locks the record so it wont appear in a query list whislt someone is in the record.
What I want to do is move it back to "Free" when they move to another record. However, this would conflict with the above code.
Is there a better way to lock the record that the user has selected so no one else can make changes to it?
