Very strange ADO cancelupdate problem

[cman]

I have a MS access database and i am using the ADO data control to access the data. When i call the cancelupdate mothod it does right the oposite as it should.
I acts the same as the update method. First i call the addnew method and then i type sth in the text box that is connected to the db. But when i call the cancelupdate and move to another record the data is stil saved into the database!
Does anyone have the solution for this strange problem?

[cman]

I think is has something to do with the datagrid that has the datasource proprety set to the ADO data control. Anybody has the solution?

[ralph]

yeah, it has to do with the datagrid.
You can try CancelBatch. It will display #Error in the datagrid cell. That will erase however upon record movement or refresh.

adodc1.recordset.CancelBatch
adodc1.recordset.move 0
is probably best