Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 698
  • Last Modified:

How do I change the recordsource of a subreport within another subreport using VBA. Changing a subreport recordsource is possible of course using VBA but I have not found a way to go another level

I am using an ADP in Access 2000  
How do I change the recordsource of a subreport within another subreport using VBA. Changing the
recordsource in a subreport is of course possible eg.
 
Reports(0)("subreport").Report.RecordSource = strSQL

but I have not found a way to do it for another level deeper. I keep getting the error messsage 'object doesent support this property or method'

 
0
HatchIT
Asked:
HatchIT
  • 2
1 Solution
 
Vadim RappCommented:
reports!report1.subreport1.report.subreport2.report.recordset
0
 
Vadim RappCommented:
or ...recordsource
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now