>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.

You can use the same technique in Visual FoxPro. Basically, you can put your calculation code in a method and call that method as indicated in my first reply. The running balance var will now become a property of the form and the code in the method you will create will get the value from that property and increment the current line value.