sum not working

[slimjen]

All, using 2010. I have a subform on a form. I am trying to show a total on the main form from the subform. On the footer of the subform; I have a textbox:

=sum([fieldname])

I put a textbox on the mainform:

]=[sfrmPayroll].[Form]![SAnnualPayrollTot

. I put the name of the control from the subform. It gives me: #error. Please tell me what Im doing wrong.

[ssanfu]

I think the problem is how you are referencing the subform control.
See http://access.mvps.org/access/forms/frm0031.htm

Something like:

Me!Subform1.Form!ControlName
or
Forms!Mainform!Subform1.Form!ControlName


Sorry I can't be more specific - I don't know your main form/ sub form names......

[slimjen]

When I put the textbox with the sum([fieldname]) on the subform and make it visible; it gives me that error. So it's before I even try to show the sum on the mainform. The field is a number data type. I can't figure out what's wrong.

[slimjen]

For some reason I got it working. Thanks

[orange]

For some reason I got it working.

Can you post the code from the "working version"? It could be useful to others.