I have a routine in a stand-alone module that handles some standard operations with controls on forms. I need it to invoke the AfterUpdate event for the control it is handling. I can't get either Eval or Application.Run to recognize the event procedure name constructed as control.name & "_AfterUpdate" no matter what I try.
Are these (Eval and Run) limited to running code in stand-alone modules? I'm thinking I just need to get the proc name syntax correct. After all, a proc in a form is just another class module, right?
I've check all the usual suspects (proc is declared Public, etc.) I've tried:
"Form_" & form.Name & "." & control.name & "_AfterUpdate" (e.g., "Form_frm_Test.txtTo_AfterUpdate")
"Form_" & form.Name & "_" & control.name & "_AfterUpdate" (e.g., "Form_frm_Test_txtTo_AfterUpdate")