Delete Error

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.

G'day,
I'm having the same problem. Any guru advise would be much appreciated. I've narrowed it down to a particular text box that is connected to my datbase but is updated by the computer, ie, selections by the user from other combo boxes updates this particular text box. If I disconnect the text box from the database the error goes away. Very annoying.

I have an idea, why not avoid using data controls. They are bulky and slow. Use pure SQL, it is fast and efficient, plus you have all of the control of the data and are not limited by the data controls.

I've been writing this program for over a year now. And I'm not full bottle on SQL. Wouldnt it take forever to change it all over from data controls to SQL? Whats involved in changing it over. Can you help?

Although I must agree straight off that's it's probably a good idea. I've noticed that my program has become very slow to load, which is actually a nightmare when your trying to debug and code