Hi Pat,
Thanks SO(!) much for your response and for your explanation. I used the AfterUpdate event and it worked perfectly (after figuring out an hour later there was a SECOND reason why it didn't work with the AfterUpdate!)
Turns out, my form has embedded subforms. I had only updated ONE...