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
680 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
  • 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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

707 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now