>>>If form has private data session than yes.
>I checked the form class and the data session is the default data session.

Put right before the select command

=messagebox(set('deleted'))

If the records are really deleted (marked for deletion) and SET DELETED is ON, then they should not appear in the result.