I have a split database. A form on the front end allows users to input their updates and then press a "Save" button to send their updates to the back end database. If two users simultaneously try to update the same record, one will connect, lock the record, and the change is committed. The other fails because the record is locked. The error subroutine for my Save button is simply "Resume btnSave_Exit". Because the Warnings are turned off, the user doesn't know that their update failed.
What I want to do is improve that error subroutine so that if User#2 hits a locked record, the function doesn't just exit the function, but instead goes back to try again. It's better to have the update go in half a second later than to not go in at all. How do I do this?