#Name? on form

Hi All,

I have numerous unbound controls on my form all with calculated values in
the detail section of the form. For example, I have one text box with
formula "=[PACE_SUMM_HEDGE]/1000000+[Hedge_adj]" as its control source. This
works fine (as does every other control in the detail section). In the form
footer I want to sum of these controls. I have the formula
"=sum([PACE_SUMM_HEDGE]/1000000+[Hedge_adj])" as the control source. This
returns #Name? - what am I doing wrong?

Thanks

double check the fieldnames in the footer control's expression, to see if
you have any typos there. also, make sure the footer control does not have
the same name as any of the fields in the expression.

hth


"kabaka" wrote in message
...
Hi All,

I have numerous unbound controls on my form all with calculated values in
the detail section of the form. For example, I have one text box with
formula "=[PACE_SUMM_HEDGE]/1000000+[Hedge_adj]" as its control source.
This
works fine (as does every other control in the detail section). In the
form
footer I want to sum of these controls. I have the formula
"=sum([PACE_SUMM_HEDGE]/1000000+[Hedge_adj])" as the control source. This
returns #Name? - what am I doing wrong?

Thanks