call procedure from another module

[John Thomas]

How do I run a procedure in my current module, which is located in another
module, The module name that I want run is Form1, in the window caption it
reads, Form_Form1:Class module. And I wan to call the procedure, Private Sub
Form_Load() in that Form1 module from another module?

Thanks John

 

[Steve]

You have to make the procedure public instead of private
in order to call it from another module.
Steve

 

[John Thomas]

I've changed it to a Public sub, how do you call it, I'm trying to do it the
following code, but it can't find it.
'Forms!Form1!.Form.Form_Load

Thanks

 

[Guest]

Try this:

Call Form_Form1.Form_Load

-----Original Message-----
I've changed it to a Public sub, how do you call it, I'm trying to do it the
following code, but it can't find it.
'Forms!Form1!.Form.Form_Load

Thanks



.

 

[John Thomas]

THANKS IT WORKED

Try this:

Call Form_Form1.Form_Load