>thisform.calc_bal code (maybe this is the part where I am messing up)
>-----------------------------------
>thisform.n_run_bal = thisform.n_run_bal + history.amount
>return thisform.n_run_bal
>
>I created a property for the form to hold the running balance: thisform.n_run_bal
Ok, I know what you meant in the first place where the value was being incremented.
The problem is that the grid is calling the method not only one time per record but each time it is being accessed.
I would suggest doing a COUNT SUM(yourfield) FOR recordbeforeorequalthecurrentone TO lnBalance.
Make sure you have a tag on the condition.
Another method will be to add an additional field in your table and avoid the calculation at run time.