I am using pessimistic buffering with pessimistic record locking.
Which means a record lock attempt occurs with the focus in any control on my form.

Right now I have an ON ERROR trap to detect record locking only in my Save button which is not enough ON ERROR trapping.

Do I have to put the ON ERROR trap in every single control on my form or is there a form-wide way to do it so I don't have to go into every control and add the words ON ERROR because I have multiple forms and many fields per form.

I could probably switch to optimistic buffering and save me some time and coding, but the next version of this software I am working on will make all of this effort null and void so I am trying to fix "Attempting Record Lock ... Press ESC to Cancel" with as little time and effort as possible.

Any suggestions? Thanks for the help.