[esmerelda]

I am trying to get some values from a report into the subreport. Although I receive no errors the values are Null in the subreport. Any assistance on where I am going wrong would be appreciated.

In the main report I have the following. The MsgBox print out correctly and the report displays the txtSelectedMonth and txtSelectedYear correctly (the values of x and y are set in Report_Open):
Private Sub ReportHeader_Format()
Me.txtSelectedMonth = x
Me.txtSelectedYear = y
MsgBox "In main_ReportHeader Month = " & x & "Year = " & y

End Sub

In the Subreport I have the following, both xx and yy are Null in the Msgbox print :
Private Sub Report_Open()
xx = Parent![txtSelectedMonth]
yy = Parent![txtSelectedYear]


MsgBox "In report open of Subreport Month = " & xx & "Year = " & yy

End Sub

I have also tried the assignments:
xx = Reports![My main report]!txtSelectedMonth
yy = Reports![My main report]!txtSelectedYear

They also still have xx and yy as Null in the msgbox printout.

Any suggestions greatly appreciated!

[OBP]

Try this
xx = me.Parent![txtSelectedMonth]
yy = me.Parent![txtSelectedYear]

But put it in the Subform's Header or Detail "On Format" Event Procedure.

Another alternative is to put those values in the Queries that supply the Record Sources for the two reports. (You do have queries, as that is what they are for?)

[esmerelda]

I added some msgbox statements in each of my subs and found that the order or execution was not what I expected. The order was
main report open
subreport open
main report_header
subreport report_header

I would have thought that it would have done both the main report open and report_header before moving on to the supreport open and report_header. What was happening was that since I can't set the txtfields until I am in the main report_header they were null (hadn't been set yet) when the subreport's report_open was executed.

My overall goal in this exercise is to have a main report call a form that asks the user for a month and year and then run multiple subreports (all with unrelated queries built in the report open and assigned via me.recordsource) using that month and year. The user only gets asked once and the subreports run contiguous on the page.

The only thing I can think of is to declare global variables in a module and refer to them. (Which I've never set up before but...)

[OBP]

Which is why you use the On Format event.
But there are other ways to pass the data to the Reports.
Is the data in XX & YY the data from the Form?
if so you can can use Forms![Formname]![Fieldname] in the Control Source of the Field.

Which version of Access do have?
Can you post a zipped copy of the database (less data) as an attachment?