Calculate totals

D

danka

Hello:

I have main form and a subform (one to many).

Form1 contains my BASE AMOUNT field. Form 2 will have multiple entries to
INVOICEAMOUNT Amount field. (one to many)

Each time a user enters a new amount I would like to show remining balance,
eg.

Remaining Balance = BASEAMOUNT minus sum of Invoice entries

Something like a running total.

I am looking for your assistance. Please help.
 
Top