Reports and variables, problems

[_Boo]

Hi so I am having a problem, I want to have my program, when the user hits generate to perform a query and them open up a separate report for each bladenumber in the query. The issue is that there is a subform in the report that I want to pass the bladenumber in order for it to requery and get results only with that number. My issue right now is that I don't know how to pass parameters to a report, and I don't know any other way to get the parameter to the subform. Any help would be awesome, thanks!

[June7]

So 'generate' is a command button with code that opens the report? You should not have to 'run' the query, the query should be the RecordSource for the report. Isn't the subreport synchronized with the main report by the Master/Child properties? You can have the RecordSource reference the control on form to get the filter criteria (the form would have to remain open when the report opens). Or you can pass filter criteria to report with the WHERE clause of DoCmd.OpenReport.

[_Boo]

Ok I got it working by using global variables, my next problem is how to open the same report multiple times. It would be optimal if I could append them so that they all appear in one tab but as different records, but I dont think that is possible(at least at my level).

   Dim rpt1 As Report
   Set rpt1 = New Report_rptBlueSheetNew
   rpt1.Visible = True
   rpt1.Filter = ""
   rpt1.FilterOn = True

[June7]

Global variable - would not have thought of that.

No, cannot 'append' multiple reports into one output. You can set up so that each bladenumber record is on it own page and with report header/footer, each page can look like an independent report.