After a successful deletion, the recordset’s field data members are set to a Null value, and you must explicitly call one of the recordset navigation member functions (Move, Seek, SetBook, and so on) in order to move off the deleted record. When you delete records from a recordset, there must be a current record in the recordset before you call Delete; otherwise, MFC throws an exception.removes the current record and makes it inaccessible. Although you cannot edit or use the deleted record, it remains current. Once you move to another record, however, you cannot make the deleted record current again. Any Delete call, even if it removes the only remaining record from a recordset, will not change the value of IsBOF or IsEOF. see also CDaoRecordset::IsDeleted BOOL IsDeleted( ) const;
CDaoRecordset::IsDeleted
BOOL IsDeleted( ) const;