I thought I came across a macro at one time that gave the original value of a field. I can’t seem to find what I need now.
I want to check the original value of a field onAfterUpdate (or onBeforeUpdate) to see if the field changed. If the original value was No, and the new value is Yes, I want to do something onAfterUpdate.
Other than doing a query on the value onBeforeUpdate, is there a macro that I can use to find the original value of the field?