Passing SQL query to a Subreport through Visual Basic

M

Matt

Ok, I'm in despirate need of help here, so any assistance would be
greatly appreciated.

I have a visual basic application that calls a report through the
Access object. Like so...

Set objAccess = CreateObject("Access.Application")
With objAccess
.OpenCurrentDatabase DataSource, False
.Visible = True
.DoCmd.OpenReport ReportName, 2, ReportFilter, ReportWhere
.DoCmd.Maximize
End With

Anyway, inside this main report sits a subreport. I currently have no
way of filtering this subreport at all. I can't link it to the main
report via the child links and parent links functions because it groups
the data.

So basically what I need is a way to send SQL to the subreport from my
VB app. OR figure out a way to filter the Subreport based upon the
main report.

Please help!!!

Thanks in advance.
Matt
 

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

Subreport doesn't work with a query 0
Can Subreport Be Made Transparent 8
Using Subreports to create a Main Report 1
How to filter data in a subreport 4
Calculate Subreport totals in a main report Group footer 3
Passing OrderBy criteria from Form to Report 1
How can I set a subreport background to transparent? 3
Retrieving a specific record from a query 2

Top