>Your method should take care of not increasing the running balance more and more.
>
>Can you give us the details on what kind of calculation you need to have? Also, it might help if you give us the table implicated in the form and the relation between them.
Here are the details on what I am trying to do:
tables
-----------------
customer
history
relation
-----------------
customer --( customer id )--> history
field
-----------------
history.amount ( fields that needs running balance for each line item)
ex.
-----------------
date descrip amount balance
01/01/97 Item 1 10.00 10.00
01/02/97 Item 2 8.00 18.00
01/03/97 Item 3 11.00 29.00
You said that I should stop it from recalcing in the method. Could you elaborate a little.