#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.


--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.


"Max" <myartsev@ilm.com> wrote in message
news:04a201c3562d$a8c1b510$a601280a@phx.gbl...

> 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