After I try to delete a record, absoluteposition gives error 1

[sergiog]

Hi I am trying to delete a record with rst.delete but Access is not allowing me because of referential integrity. I trap this and I exit the sub.

So far so good.

bu when I try to do rst.absoluteposition = 5 to move the recordset pointer I get an error saying Row handle referred to a deleted row or a row marked for deletion.

any ideas pls ?
thanks
sergio.

 

[CCLINT]

When you capture the error, try calling the rsADO.CancelUpdate (or CancelBatch depending on the CursorLocation) method.

 

[sergiog]

thanks CClint...it worked with cancelupdate.