By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,080 Members | 1,276 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,080 IT Pros & Developers. It's quick & easy.

Access Subreport objects from vba code

P: n/a
How can I access subreport objects from vba? Sample code would be
appreciated.

Mar 8 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Roger" wrote
How can I access subreport objects from vba?
Sample code would be appreciated.


Forms embedded in Subform Controls and Reports embedded in Subreport
Controls are not "open" and will not be found in the Forms and Reports
collections, respectively. They exist as the Form or Report property of the
Subform or Subreport Control, respectively, in which they are embedded.

If the code is in the module of the Report embedded in the Subreport
Control, using the "Me" shortcut is the simplest way. If the code is in the
module of the Report in which the Subreport control is embedded, then

Me!NameOfSubreportControl.Report!NameOfControl

If the code is outside the Report hierarchy, as in a standard module:

Reports!YourRept!SubreportCtlName.Report!ControlNa me
Mar 8 '06 #2

P: n/a
Thanks

Mar 9 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.