SUM in form footer !

[prakashwadhwani]

I have a continuous form with 2 fields OPBAL and INIT_BAL as the
control source.

In the form footer, for their totals I have 2 text boxes having
=Sum([OPBAL]) and =Sum([Init_Bal]) as their control source.

This works fine !
If however, on the form I change the name of the fields to Txt_OPBAL
and Txt_Init_Bal
the sum in the footer which I now change to Sum([Txt_OPBAL]) and
Sum([Txt_Init_Bal]) shows an ERROR#.
Is it imperative that to get a total in the form footer both, the
Control Source and NAME should be the same ?

Rgds,
Prakash.

[Allen Browne]

You can sum a field in the form's RecordSource.
You cannot sum a control.

Therefore your expression needs to refer to the field name (typically what
you put in the control's Control Source), not the control name.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
<pr*************@gmail.comwrote in message
news:11*********************@o61g2000hsh.googlegro ups.com...

>I have a continuous form with 2 fields OPBAL and INIT_BAL as the
control source.

In the form footer, for their totals I have 2 text boxes having
=Sum([OPBAL]) and =Sum([Init_Bal]) as their control source.

This works fine !
If however, on the form I change the name of the fields to Txt_OPBAL
and Txt_Init_Bal
the sum in the footer which I now change to Sum([Txt_OPBAL]) and
Sum([Txt_Init_Bal]) shows an ERROR#.
Is it imperative that to get a total in the form footer both, the
Control Source and NAME should be the same ?

Rgds,
Prakash.