Subform!

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
 
J

John Vinson

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?

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top