>I have a datagrid linked to an Adodc control.
>When the user doubleclicks a row, my program transfers data from this datagrid to textboxes on another form.
>The user can modify the data and then click the Add button to add this new record to the recordset.
>A check for a duplicate record is made before the addition.
>
>I get the following error message when I press the add button:
>Microsoft Datagrid control error 2147217842,
>the change was canceled during notification, no columns are changed
>and the .addNew statement is highlighted
Is your recordset still connected?
Show us some code.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com