#Error in Form Footer for =Sum

[Elvis72]

I have a form that was working perfectly...then I had to change some things in the query.

NOW that I open the form it is showing me #Errors in the
Sum text boxes I have in the Form Footer.

It didn't do this before, and the names of the Fields in the Detail did not change?

So, I can't figure out why???

Thanks!~

 

[genomon]

When you "changed some things" in the query, a field name that was there before was deleted or renamed something else (add any aliases?). The text box is pointing to a recordsource that no longer exists.

"Business conventions are important because they demonstrate how many people a company can operate without."