Report query

[Guest]

I have constructed reports with sub reports that obtain thier data from a
query.
My question is is it possible to change the query that they are bound to
using vba?
Thanks
Ian

 

[Allen Browne]

You cannot use the Open event of the main report to change the RecordSource
of the subreport, because Access opens the subreport first.

You cannot use the Open event of the subreport. The main report repeats the
subreport each time it needs to, and you cannot reassign the RecordSource
differently for each time it is called.

You can change the SQL of the query that the subreport is bound to before
you open the main report. For example, if the subreport is bound to Query1:
CurrentDb.QueryDefs("Query1").SQL = "SELECT ...
DoCmd.OpenReport "Report1", acViewPreview