How do you call subform subroutines from main form?

L

Lawrence Mak

As titled.
I want to be able to call subroutines that reside in a subform from a main
form. Any help appreciated.

Lawrence Mak
 
B

Brian

Lawrence Mak said:
As titled.
I want to be able to call subroutines that reside in a subform from a main
form. Any help appreciated.

Lawrence Mak
Click to expand...

Assuming the subform control is called subMySubform (that's the subform
CONTROL, the name of the form itself is irrelevant), and the procedure you
want to call is named MySubProc, then:

Me.subMySubform.Form.MySubProc
 
L

Lawrence Mak

Thanks!

Brian said:
Assuming the subform control is called subMySubform (that's the subform
CONTROL, the name of the form itself is irrelevant), and the procedure you
want to call is named MySubProc, then:

Me.subMySubform.Form.MySubProc
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
Populate main form from subform record 0
main form/subform 1
Subforms within a Tab control 4
Strange Subform behavior... can someone help? 3
Call Public Sub in a SubForm 5
VBA code returns no records hwenKey ID is added 14
Call subroutine or set property on another form 3

Top