This is probably an old chestnut. For various reasons we need to retain the Close "X" button on a form
If the User is in the middle of an edit and clicks close, they get the option to save the record. The validation therefore has to be called from the "Before Update" process.
If validation fails, we use "Cancel = True" so the record is not saved and return them to the form.
However "Cancel = True" removes all of their changes.
How do I retain the changes and give them the ability to fix them before they exit?
I really need an "On Before Close" trigger that is called before the "On Before Update".
Having struggled with this all weekend I would really appreciate some help.