Hi Dore,
Thanks for your reply. I thought that DELETE was only supposed to delete the current record?? In any case, it wasn't deleting the current record and I had to resort to the SQL-DELETE to make it work - and then move to the previous record and refresh the form to avoid an EOF() error.
>My guess is that the record pointer was at EOF() when you issued the DELETE command. The default scope of the DELETE command is NEXT 1. If you had put the same conditional "alltrim(tblbranchadmin.branchnumb) = alltrim(thisform.brnumb)
>" as part of a FOR clause in your DELETE command it would have worked because then the default scope would have been ALL (that met the conditional). Instead you used SQL - DELETE which operates on all of the records that meet the WHERE condition.
>
Al Williams
Anola MB, CANADA