I am doing an Access97 report that is straight forward.
A master report that has no data to report, just 2 subreports (which I'll call Sub1 and Sub2) in the detail section with a page break between them . The only thing the master has to print are the page headers and footers for the fused subreports. I did this so that I have a hdr on each page (subrpts will not print pg hdrs).
All works perfectly except the header should inform audience which level of the report they are reading (i.e. "My Report * Level 1" or "My Report * Level 2"
. The problem is that I need to control the data in the text box on the parent from the subreports or possibly have the parent report determine which subrpt is current to do the page header for!
I haven't been able to set values from subrpt events because for example if I set it in the OnOpen in Sub1, the header only has the Sub2 header because parent opened Sub1, then Sub2, then started reporting them using Sub2 header info!
Any other ideas would be appreciated!
A master report that has no data to report, just 2 subreports (which I'll call Sub1 and Sub2) in the detail section with a page break between them . The only thing the master has to print are the page headers and footers for the fused subreports. I did this so that I have a hdr on each page (subrpts will not print pg hdrs).
All works perfectly except the header should inform audience which level of the report they are reading (i.e. "My Report * Level 1" or "My Report * Level 2"
. The problem is that I need to control the data in the text box on the parent from the subreports or possibly have the parent report determine which subrpt is current to do the page header for!I haven't been able to set values from subrpt events because for example if I set it in the OnOpen in Sub1, the header only has the Sub2 header because parent opened Sub1, then Sub2, then started reporting them using Sub2 header info!
Any other ideas would be appreciated!
