Deleting a record from recordset

[deepak_r_patel]

I am trying to delete a record from the recordset. I am using a transaction. After deleting a record & commiting I am getting the error - <A given HROW referred to a hard- or soft-deleted row.> - The record gets deleted from the database also. The delete works perfectly for some forms and is not working for some other forms.

[Cimperiali]

maybe this is not the point, but try refreshing recordset after the delete

Special thanks to Lothar "the Great" Haensler, Tom Archer, Bruno Paris and all the other wonderful people who made and make Codeguru a great place. Come back soon, you Gurus.

[deepak_r_patel]

Thanks for the reply.

As soon as I write recordset.delete, the AbsolutePosition and Bookmark of the recordset shows me the said error. I am using Requery method of the recordset but the control is not reaching there.

Thanks
Hitesh

[Cimperiali]

after delete, before invoke absloute position, try
yourrecordest.refresh

Special thanks to Lothar "the Great" Haensler, Tom Archer, Bruno Paris and all the other wonderful people who made and make Codeguru a great place. Come back soon, you Gurus.