calling subs

[emptywords]

does anyone know how to call sub from another form?

for example, i am working with form 1, but i need to call a command1_click() from form2, does anyone know how to do this?

-emptywords

[wossname]

Dead easy.
There are 2 ways to do this...

Change the Command1_Click Event to Public instead of Private. Then in Form2 use...

Call Form1.Command1_Click

Or, you could dump all the code from that event into a public sub inside a module, then you can call that code from any form you like.

The second way is safer, but make sure it doesnt throw any of your variables out of scope.

[Matthew Gates]

You could also set it's Value property to True, which will also call the Command1_Click event.

Form2.Command1.Value = True

[wossname]

Matthew, yeah but why do it the easy way when you can risk throwing all kinds of bugs into the program with my method!

ps. Won't your way force a refresh of the button's graphical DC clipping region?

[parksie]

Is that a particular problem?

[Megatron]

Originally posted by Matthew Gates
You could also set it's Value property to True, which will also call the Command1_Click event.

Not all controls have a Value property. Also, What if the sub being accessed was not an sub linked to an object?

[Matthew Gates]

Only talkin' about a Command Button here .