Ok, Crazy,

Here is a function that will delete the current record and make that
annoying #Deleted# disappear.

If you have a Delete command button on the form, call it like this:

DelCurrentRec(Me)

I have this function is a Standard Module so I can call it from any form.

Public Function DelCurrentRec(ByRef frmSomeForm As Form)
Dim rst As Recordset

   On Error GoTo DelCurrentRec_Error

   Application.Echo False
   With frmSomeForm
       Set rst = .RecordsetClone
       rst.Bookmark = .Bookmark
       If .Recordset.AbsolutePosition > 0 Then
           .Recordset.MoveNext
       Else
           .Recordset.MovePrevious
       End If
       rst.Delete
       If .Recordset.AbsolutePosition > 0 Then
           .Recordset.MovePrevious
       Else
           .Recordset.MoveNext
       End If
   End With
   Application.Echo True
   
DelCurrentRec_Exit:

   On Error Resume Next
   rst.Close
   Set rst = Nothing
   Application.Echo True
   Exit Function

DelCurrentRec_Error:

   MsgBox "Error " & Err.Number & " (" & Err.Description & _
       ") in procedure DelCurrentRec of Module modFormOperations"
   GoTo DelCurrentRec_Exit

End Function

I've only seen this when the data is stored in a non-Access database - dBase
in particular. Compacting the backend (or whatever the dBase jargon term for
garbage collection is) will solve the problem. Where is this data stored?

            John W. Vinson [MVP]