Errors in total row footer on form

[Al]

I have a total row in the footer of my form with text boxes carrying the
totals of my fields for that record. However if I have more than two text
boxes, I get an "#ERROR".
Access doesn't give any further information

 

[Allen Browne]

As soon as Access is unable to calculate one of the calculated controls, it
gives up on the others too, so it is possible that the 3rd one had an
incorrect expression, and so the other 2 errored out as well.

Try the 3rd one on its own, until you get it right, and then add the first 2
back again.