Can I assume you're using unbound forms?
If that's the case, then just write the code before your update statement.
If you're using bound forms, then it's a bit messier, and you'll probably have to end up putting code in all your bound objects' After Update events.
So what's it to be? Bound or unbound?
I am a loud man with a very large hat. This means I am in charge