Subform!

  • Thread starter Thread starter Floyd forbes
  • Start date Start date
F

Floyd forbes

I have a combox on the main form that filters the customers in the subform.
How do I calculate the totals of each customer in the subform with a text
box on the main form?

Floyd
 
I have a combox on the main form that filters the customers in the subform.
How do I calculate the totals of each customer in the subform with a text
box on the main form?
Click to expand...

Put your totals expressions (whatever they are, you don't say) in the
subform's Footer. For instance, if you have a field named Amount in
the subform's recordsource, you can put a textbox txtTotAmount in the
subform's Footer; set its Control Source to

=Sum([Amount])

Then on the mainform put a second textbox with a control source

=subformname.Form!txtTotAmount

where subformname is the name of the *subform control* - the box
containing the subform; this isn't necessarily the same as the name of
the form therein.
 
Back
Top