I have a subreport in a group footer of my main report. My subreport report_open function changes the subreport RecordSource. For the first groupfooter output (which happens to be grouped by year), it runs fine, updates the RecordSource and I get the correct totals for that year. However, the subreport report_open() function never appears to be called again and the first set of totals appear for all years (groups). I confirmed that the subreport report_open() function is only being called once by putting a msgbox call in the report_open() routine. I only ever get one msgbox display regardless of how many years I am subgrouping.
How do I get a VBA report to call the the subreport report_open() function FOR EACH subgroup?