"clicking" 2 buttons on another open form, via vba

[snipe]

Hey guys,

I have 2 open forms. The active one has a button that runs a sub. The sub calculates 2 dates. The 2 dates are then pushed to the inactive form. This works perfectly. Next I need to "click" 2 of the buttons on that inactive form. Those 2 buttons have relatively large subs.

I have read that this can be accomplished via Form_frmName.SubName() but that is throwing an "expected =" error.

Any help would be appreciated!

Thanks!

[June7]

That's because it thinks that is a function. Try:

Call Form_frmName.SubName

Make sure the event is not declared Private.

[snipe]

One more snag, the form name has a space (I didn't design this one..) , what is the proper way to bracket or quote it?

[June7]

This also works:

Call Forms("form name").SubName

[snipe]

Perfect. Working great. Appreciate all the help!