Call routine on subform

S

smk23

I need to call a sub routine on a subform from a main form. How would I code
that? Thanks!
 
D

Dirk Goldgar

smk23 said:
I need to call a sub routine on a subform from a main form. How would
I code that? Thanks!
Click to expand...

The procedure on the subform must be defined as Public. If it is, you
can use syntax like this to call it:

Call Me!SubformControlName.Form.YourSubName

or just

Me!SubformControlName.Form.YourSubName

That's assuming that the procedure doesn't require any parameters.
 

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

Word VBA - Delete text from bulleted paragraphs 1
Populate main form from subform record 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Trouble with Find and Replace vba routine 2
applyfilter to an unbound subform from a module function 7
VBA for updating Resource's ActualWork 0
non basic code in call stack 3
Adding a new record to a subform 1

Top