#Error when summing in Form

[iamnu]

I add a NEW control to the Footer of a Subform with a Control Source
as follows: =([AmtBilled]). This will give me a value from a record
of the Detail section of the same Subform.

If I change the Control Source to =Sum([AmtBilled]), I get #Error.

All of my controls that contain the Sum function are NOW giving me
this #Error. I made this to happen with some change I have made, but
I can't figure out what I have done to cause this.

Can someone point me in the direction to solving this problem?

Thanks...

 

[Dorian]

You need to sum by control name not by column name.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".