Calling command button from another form

[Nermal52]

I have written a procedure that runs when a command button is clicked in the subform. I would like to call this procedure from another form so that instead of clicking the button in the subform, the user can click a button in the main form and execute the code (I eventually want to hide the subform).
I know that in VB you can call a command button by using FormName.cmdbutton_click. However, I can't seem to get this to work in VBA.
Can anyone help?
Thank you!

 

[Databaseguy]

Why not just make the procedure a Public Function and call it ??? Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy

 

[Nermal52]

I tried to do that, but it didn't seem to work. I tried naming it Public Function AddAncestry() and then calling it in the main form as AddAncestry(). Can you see anything wrong with that?

 

[Alcar]

If it doesn't return any value, don't use Function but use Sub instead. Second, when you call you sub, don't use the parenthesys.
HTH
Alcar

 

[UncleJack]

Perhaps your function has a Me! operator in it that would make it fail when called from another location. Either make it public or put it in a module; I prefer the latter because it's easier to find.

Uncle Jack