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
 
Top