sum values from details in the subform

[Guest]

i have a form with customer name that i can specify, and by defining the
customer i will have detail revenue info by product in the subform.

Now i want to have another column in the main form showing the sum revenue
(of all products) belonging to this customer, should I link the code to the
customer column or to the subform?

I am trying to write a code that leverage a query, how do i link a query to
an interactive form like this? Any comments will be very appreciated.

 

[John Vinson]

i have a form with customer name that i can specify, and by defining the
customer i will have detail revenue info by product in the subform.

Now i want to have another column in the main form showing the sum revenue
(of all products) belonging to this customer, should I link the code to the
customer column or to the subform?

I am trying to write a code that leverage a query, how do i link a query to
an interactive form like this? Any comments will be very appreciated.

Sorry to be so late replying to this.

You can put a textbox on the Footer of the subform with a control
source

=Sum([Revenue])

to sum the value of the subform's recordsource field of that name.

Neither this sum nor the individual by-product sums should be stored
in any table. Just calculate them as needed.

John W. Vinson[MVP]