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.