>>Hello all. I need to find a way to add a running balance column to a grid. This grid contains line items for a customer. The balance needs to be calculated each time the grid is displayed and it is a multi-user system. Any help would be useful. Thanks in advance.
>
>You can use a dynamic field. Instead of indicating the table.field in the ControlSource property, you can indicate ThisForm.YourCalculateMethodHere().
Thanks for the help. I can get it working this way but how do you stop it from recalcing the column over and over again when you scroll. Which keeps increasing the running balance more and more. Any more help would be useful. Could you be a little more detailed with the solution maybe I am missing something. Again thanks.