I have a main report which has 2 section levels above detail. I am using the =[Page] to assign and display rhe page number on this main report. I use the same report as a Subreport to the main report and I hide the Detail section, but the page number assignment reduces to just those pages in the 2 section levels (the detail pages have been excluded since I have hidden the detail section on the Subreport). The Subreport is placed in the Report Header of the Main Report. How do I capture all of the page numbers from the main report which includes the detail section for subsequent use (i.e, display in the Subreport)? Can I use an event or action to capture the main report page number value for subsequent use (possibly place the value in a table with an Update Query and then select it with a query for use on the Subreport?
It may not be a capture problem as much as it is a Link problem between the Main Report and Subreport?
