I have my same old main form with a million subforms. Sometimes the subforms have no data and i am trying to print the rest of the report normally. But I continually get the #error on my totals control.
So here is how it works - well actually it doesn't work....lol
On subform 'FaR' I have the following fields which are populated, or not populated, from one of my queries:
Field1 is a total field from the query
Field2 is a total field from the query
Both of these fields are hidden
Field3 is the sum of Field1+Field2 and shows on the report
Very often Field3 has no value.
Then on the Report footer I have Field4 which sums Field3 when it has a value.
On the main form I have Field5 which is a total for Field3 on this report and another field from the previous subreport. It is this Field which is upsetting my hairdo!!!! Always returning a #error when all the above fields have no values. It all works just fine and dandy so long as there are values but when there are no values, welllllll............???????
The current calculation I have there is =FaR.Report.FATot+CaR.Report.CATot
I have tried IIF stuff everywhere I can think of and the same for Nz.
Can someone please point me towards the correct Field that I need to concentrate on to fix my problem.
I am really sorry.....it is all reports and subreports
I have tried your suggestion and when I try to open the report in form view I get the little box asking for the parameter(?) value for say "FaR,0"