Sorin,

<< I want to delete the record from the tbMain table if the EOF is true. I
don't get any error but the expected record isn't deleted and it should. >>

If you want to send me your database (catalog and table files), I can take a
further look at this.  If the SELECT is actually returning an empty result
set, then EOF() check should work.

--
Tim Young
Elevate Software
www.elevatesoft.com

Sorin


Contacts was one of the tables I tried it on - I missed it when posting.

Licence is granted on the basis of its your funeral

Roy Lambert