Feels like this should be easy, this is what I am trying to accomplish
I want to check a value on a text field when it is about to change and display an error message if it was changed to an illegal value then if it is, change it back to the prior value. (e.g. email address on Customer entry)
I had hoped that if I did a “Before CustCnt_EMailAddress_ColumnChanged” I might catch the value, save it to a TransView field, check for error on the new value, and put it back if it was an error, but that kind of thing doesn’t appear to work (I get the updated value not the old value in the event).
My other thought was to save the value on Load and Save and the do the check after it changes, putting the saved value back if necessary.
That just sounds like a mess, what am I missing ?
Or maybe I just have to perform the check on Save and if it’s an error prevent the save and the user has to fix the issue ?