I have a data entry form I set up in Access. It is a continuous form, and has a footer which accumulates field totals. I set up my totals with the =sum([fieldname]) in the Control Source property and it was working, but for some odd reason it stopped working and all I get now are #Errors. I've double-checked the Syntax and spelling and don't see any issues. Any thoughts on what might be causing this error?