Access 2007 Macro1 - RunMacro - MyMacro

[jslmvl]

Hello.

When I run Macro1 in its design view, I got error message
Microsoft Office Access can't find the object 'MyMacro.'
What I set is
In Macro1 design view, Action: RunMacro, Arguments: MyMacro
where MyMacro is a Sub in Module1.

I will be appreciated for any help.

 

[PHV]

I'd use RunCode and make MyMacro a Function instead of a Sub

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jslmvl]

Thank you PHV.

I have just tried to change the Sub to Function but got the same error!

 

[PHV]

Did you change RunMacro to RunCode ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886