Sum error on continous subform

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