Help getting Total from Subform on Form (Again)

[GregShah]

I have completed this task before on other DBs but something is happening differently here.

I created two different sum boxes and placed them in the footer of the sub. I then created two boxes to bring the sum back to the main form. I tried different formatting but neither works. Can anyone see what's glitching this process?

Thanks,

Greg

[ranman256]

Did you use the Builder to enter the path of the 2 sub form boxes?

[CJ_London]

1. your first sum in the subform footer is for [total wgt] - there is no field called [total wgt], although you do have a control called [Text34]
2. I'm pretty sure your sums need to be of field values, not control values since I don't think they work with unbound controls

[GregShah]

No. I simply use the sum function. I will add some protection for empty or zero values once I get the total working in the simplest version.