Unanswered: datagrid is updated when a focus moves out of the cell...
I have a datagrid associated with the recordset object.
There are insert/update/delete buttons in the same screen to do respective operations on the grid.Delete and Insert works fine.But when i change some cell value and move the control out of cell it automatically updates the grid and in turn updates the database table.But i want this should be only updated after clicking the Update button.
In simple the changes should be saved to the database only after clicking the Update button.
I feel AfterColUpdate and BeforeColUpdate events will not solve this problem.