Calculated fields on subreports

[Kozbot]

Hello

I have a report with 4 subreports. The report contains calculated fields that use the totals field in the different sub reports.

My issue is when one or more of the subreports does not have data in it. The sub report dissapears while in print preview, removing the totals row and ruining the calculated fields in the main report.

How can I keep the sub report visible even if no data is displayed? Or have it invisible but have the calculated fields still reference. Or is there another solution.
Thank you

 

[pbaldy]

One way:

http://access.mvps.org/access/forms/frm0022.htm

 

[Kozbot]

One way:

http://access.mvps.org/access/forms/frm0022.htm

Thank you!!

So I insert this code into a "global module" and it will work for any form with subreports?

 

[pbaldy]

Happy to help! Yes, it should.

 

[Kozbot]

Happy to help! Yes, it should.

I copied the code into a module however my subrpt is still dissapearing in print preview and messing up my calculated fields.

 

[pbaldy]

Did you use the function in the calculated fields?