Hi
Try with SET DELETED ON

>Hi Mike
>
>Sorry but I was studying the code and I found that the REQUERY() was still in the code. As soon as I removed the REQUERY() preceding our updated SELECT statement the whole thing started behaving as before, the deleted record won't go away.
>
>Please advise.