using calculation as control source

[jamaarneen]

Hi
There are some threads about this, but stil cannot get it:

In the form-header of a bound form - continuous, I have a text box. I want it to give me the sum of a field.
So I'm trying to put a Sum() function as the Control source, but I'm getting an #error.

=Sum([Field 1])
Field 1 is the name of a field wat's bound to the form

Thanks for your Help
Ja

 

[dhookom]

Can we assume [Field 1] is the name of a field in your form's record source?
Also, make sure the name of the control is not the name of any field.

Duane
Hook'D on Access
MS Access MVP

 

[jamaarneen]

Yes, Duane, [Field 1] is the name of a field in the form's record source.
And, no, the name of the control is not the name of any field.

But I did something,and it is working (for now...)

I actually have more then one field. so i was triyng different ways:

for field 1 it was refering to the sum of the field itself: =Sum([Field 1]) ;
for field 2 it was triyng to sum the contents of the textboxes (bounded)on the form: =Sum([txtField 1].[text])

now I have changed the syntax of field 2. And it WORKED

Thanks anyway