I have a main form, single form view. And then in that form, a sub-form whish is a datasheet view. In the footer section of the subform I am trying to sub the value of a field named txtGross (Gross is the control source).
What I have for the field's control source in the footer is =Sum([txtGross])
But I'm getting #Error.