#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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum on footer returns #Name 3
Access Form Refresh 1
Using DSUM to get running total on a filtered form 0
PROBLEM: Subform total on main form returns #Name 5
Main Form / Subform Totals 3
Running Total from a Subform 1
#Error when summing in Form 1
Total in a subform 1

Back
Top