I have a grid on a form displaying a view. On the bottom of the form are column totals. I update the column totals by doing SUM col1, col2 , etc. TO total1, total2, etc. in the LostFocus of each textbox. Here's my problem...

If I use Table buffering and check for a row change in the AfterRowColChange event to do a table update, I run into a problem with locking up the application. I admit that there is A LOT happening with the validations and summing, I even have quite a few Dynamic events for the grid. I've tried to reduce the processing, but I still get locked up.

So, OK, I change my buffering to Row and now I don't have the locking up problem. But I would still like to have the ability to cancel the changes to the current record. But since the SUM is running from the LostFocus event, the RECNO() gets changed in the process of summing before the TableRevert() is issued (making the change to the current record update to the source table).

What I have done is disable the TableRevert(), but I really would like to have it back.

Does anyone have any suggestions?

Thanks.