#Error in form calculation

  • Thread starter Thread starter Max
  • Start date Start date
M

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
 
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.
 
Back
Top