Revert Field to Last Value
I have a layout with 2 fields. A name field, and a type field.
If the user changes the type (pop up menu), I have a script to check if the record is in use - in which case I block any changes.
Checking if the record is in use is all set and it works. The problem I have is reverting the type field back. I would like to avoid having to revert the whole record if possible, because I'll alloy changes to the name at any time.
I was thinking that when the user enters the field I would "grab" the existing value, but the script triggers don't work that way for pop ups.