>I meant that your method will be called for each record but it should not increment the value.
>
>Ok, can you give the formula needed to calculate the balance?
The formula is just sum all the records prior to the current line item and include the current line item.
Are you saying that I must sum all the line items each time I want a balance for a certain line item. I cant reuse the running balance from the previous line item and just sum to it? I used to do this with Foxpro 2.5 for Dos by using a calculated field. And in the function just kept adding the current amount to the running balance var and returned it back to the calculated field. Hmm. Maybe thats not possible with VFP because of the refresh issues. Please confirm this. Thanks.