I have a split database. The back-end file is on a server. The front-end file is on every user's computer and is linked to the back-end.
If user #1 has a record open via a form and user #2 tries to open the same record I want a message to be presented to user #2 indicating that the record is in use and prohibit them from getting the record to display on their form.
How can I do this?