I have a form that multiple users will be using to view/edit records at the same time.
To prevent data from being edited by 2 people at the same time I am using the following method:
I have a table called Tracking that has the following fields
ID (primary key)
Lockstatus = 'Open' or 'Closed'...
