Hi all,

I make a simple form in VB6 to input / edit Personal data.
I use one Adodc and some commandbutton and text box.

Everything is ok ( I can Add new, cancel , edit, etc).

Then I add a Datagrid to the form only to show ID and Name.
I use one Adodc for all of them.

Everything is ok, except one :
If I add a new record ( adodc1.recordset.addnew), then
I cancel it ( adodc1.recordset.cancelUpdate ) , an error message appear :
... they would create duplicate value in index, primary key ........

My database have primary dan index, but in this case I don't make any new record.

Can anyone please tell me how to avoid this error ?

Thank you
Rudy Ong