I have a form designed to allow the user to modify historical data. At the form level, I attached code to the before update. When the user leaves the record, this code is triggered. The code displays a form that captures user id, date, time and shows the user which fields were changed. Then the user is able to accept or discard changes. When the verify form is closed the changes are written/not written based on the users response.
However, I have run into an issue with the before update event.
-I change the quantity field from 1 to 5.
-Then, instead of moving to a different record, I click in an unbound search field I have provided for the user to search for records.
-The before update event does not fire when I move to the unbound field
-If I enter a search term and hit the enter key, my verify screen appears.
-However, because I am no longer on the record, the update bombs.
My question is: How do I get the before update event to fire when moving to the unbound field.