Just when I thought I knew everything there was to know about Database Programming, I came across this problem. On a form I have a DataGrid and Several Text boxes. The Datagrid and the textboxes are all linked to the same Data Control. The text boxes are used for Data Input and the Grid is used to display the records in the table to wich the Text boxes are linked. Now, it works fine when I add a new record, but when I try to delete a record it generate's an error stating 'A given HROW referred to a hard- or soft-deleted row.'

Can someone please tell me why it does this and how I can get around it.

Thanks.