#Name? on form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top