Access Continuous Form Subtotal Textbox #Error
Posted on 2014-02-18
I have a form with a subform. The subform's info comes from a query. In the Footer of the Subform I put an unbound textbox.
The continuous form's bound field is [AmtIn]. In the footer I put the formula
Everything works great EXCEPT when the query results in "No Records". Then I get the dreaded #Error which throws every other calculated field on the Form to #Error.
Am I doing something wrong or is this a Access 2007 bug that was never fixed?