In my opinion, the easiest way is to put a hidden textbox in the footer of
the subform. Set its controlsource to =sum([ticketweight])
Then put a textbox on the mainform and set its controlsource to
=([name of the subform control].form![nameofthetextboxinsubform])
--
Milton Purdy
ACCESS
State of Arkansas


"Jeff via AccessMonster.com" wrote:

I have been pulling my hair on this one.
I will try to use the proper terminology to describe my problem...
On the header of a continuous subform I would like to calculate the sum of a
field on my subform.
On the subform, the control name that is to be summed is TicketWeight1. Its
field name (control source) is TicketWeight
In the header of the continuous subform, I have a control named
Ticketweighttotal which control source is =Sum([TicketWeight])
This returns Error in the control
The TicketWeight field name is a field in the underlying table and not the
result of a calculation.

Jeff Sauzeat

--
Message posted via http://www.accessmonster.com

.