Solved

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

Posted on 2008-10-24
4
691 Views
Last Modified: 2013-12-05
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
Comment
Question by:HatchIT
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 40

Accepted Solution

by:
Vadim Rapp earned 500 total points
ID: 22803386
reports!report1.subreport1.report.subreport2.report.recordset
0
 
LVL 40

Expert Comment

by:Vadim Rapp
ID: 22803405
or ...recordsource
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question