Sum of Detail on Main Form

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

I'm trying to put a control on a main form which sums the
values of a control in the subform. The control name of
the subform is "sbfdetail", the control I'd like to
summarize is "SF".

I've assigned the control source as:

Sum(Me!sbfdetail!SF)
Sum(Me!sbfdetail.Form.Controls!SF)

both of which report "#Error".

Can anyone help?
 
Using Access 2000

The way I did this was to place a hidden field on the subform (txtSumSF)
with a control source of for eg =sum(SF) and then placed a control on the
main form that referenced it
i.e data source = subformname.Form!txtSumSF

HTH

Ali
 
The way I did this was to place a hidden field on the
subform (txtSumSF)
with a control source of for eg =sum(SF) and then placed
Click to expand...

Thanks a lot, "Newbie". It works, and makes the
application a lot simpler.
 
Back
Top