Total from subform column?

[CyberRaptor]

I need to sum the records of a field on a subform, and display it in the main form. I read that you have to place a text box in the subform footer using =Sum to do this first, since it wouldn't work at all if when I just tried it in the main form. It still produces erroneous numbers though, and I'm not sure how to provide the main form with a reference to the control there. Would someone please tell me how to do this?

[amrut]

Open subform in design view place a text box named "Total" in the subform footer and set its control source to =Sum(YourField)
On the main form, place a text box and set its control source to =[YourSubformControlName].[Form]![Total]
YourSubformControlName is the subform control name on the main form.
If you do not want show the text box "Total" on your sub form set its height and form footer's height to zero and Visible property to "No"

[CyberRaptor]

Thanks! That appears to have done the trick.