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