#Error in form calculation

[Max]

I get #Error in a simple =sum([Field1]) calcualtion in a
form's footer. Same formula works just fine in another
form. What could be a reason for the formula to error, and
what are common causes for #Error in Access forms?

Very much appreciate the help! Deadline tomorrow morning!

Max

 

[Fredg]

Max,

If the name of your control is Field1,
change it to something else, i.e. txtField1
You will get an #error if the name of the control
is the same as the name of a field used in your expression.