I am trying to run an 'After Update' data macro where I create a record in another table ONLY if any of 3 fields are changed. Otherwise, I do not need to log any of the changes.
Problem - I am attempting use a 'local variable' that I set in the beginning of the data macro to tell me if indeed any of these fields have changed. However, I never get a new record created. I believe that I may not be referencing the local variable correctly.
I have attached a screen shot of the code for your review. I hope this is a quick fix that someone out there can help me with.