run macro from other form

[pbennison]

Hi all,

Hopefully an easy one but i can seem to find an answer on the net

I have a form with a button which when pressed need to run a macro which sits on a different form

i have tried run macro ad do cmd but none of these work.

Help please ?

 

[Cronk]

The scope of a function or Sub in a form is restricted to that form.

Either move the code to a module, and call it from both places, or another way is to set the Timer event in the form holding the code, which in turn causes the code to execute.