Subform Totals

[phuser]

I will try to explain this as best I can, I have a form for suppliers with
the ability to Add Suppliers, that form also contains a subform from a table
invoice totals, for invoice history (no data entry to subform) on the next
(tab) page is for the user to have the ability to pay these invoices, I have
made the payment method, cheque number bound to the payments table and have
an order sub form with the ability to put in the "amount paid" if wanting
to pay that invoice, what I need is for a text box to add up the amounts
paid for each invoice and supplier window during that session, like a
running total amount that confirms the cheque amount is correct. I know I
have to make a text box that would hold the expression, I just dont know
how, and if new suppliers were added would they be included in the
expression?

Pleassssssssssssse

 

[phuser]

I think I got it, if I make a payments detail table like that of the invoice
details table it could group the invoices paid by cheque number then a query
to total those amounts could be inserted into a text box like that of a
subtotal !! Am I on the right track?