Updating totals for a data grid when data changes
I have a data grid and separate totals fields. If I create a button off to the side, I can have that button update the total with the sum of a column of numbers in the data grid.
What I cannot get to work, is to have the On Change event of a field in the data grid trigger the update of the total. The way I would like it to work is that if the data in the data grid is edited, the totals recompute automatically. The best I get is that the total gets computed as the value that has just been changed multiplied by the number of rows (instead of the sum of the value in all the rows).