I'm hoping someone out there has hashed through this one before and can give me some info.
I'm writing code to capture the file that a user links to an OLE field in order to copy the file to a secure directory and then re-link the control to the copied file (to prevent users from linking to something on their hard drive or other unsecured location).
However, I'm finding that the AfterUpdate event of this control does not fire when someone inserts an object through this control. The OnUpdate event fires, but it thinks the control is still null--so it must fire before the link is created. I'm now down to LostFocus but that will mean that my code will fire at times when I don't need it to.
Has anyone fought their way through this tangle before? Is there a way to ensure that the AfterUpdate event fires?