Getting rid of "#deleted" (repost) 1

[rcoutts]

I have a subform that has a datasheet for a table that am clearing with a Delete Query and then setting new values in the table with "DoCmd.GoToRecord , , acNewRec." It works fine, except that after running the Query, Datasheet view of the table looks like this:

    Category     Description  Subtotal
    --------     -----------  ---------
    #Deleted     #Deleted     #Deleted
    #Deleted     #Deleted     #Deleted
    #Deleted     #Deleted     #Deleted

I call "DoCmd.GoToRecord , , acFirst" before writing new records, but everything getting appended. E.g.,

    Category     Description  Subtotal
    --------     -----------  ---------
    #Deleted     #Deleted     #Deleted
    #Deleted     #Deleted     #Deleted
    #Deleted     #Deleted     #Deleted
    Balance      Amt Forward     $1000
       ...          ...          ...

But, when I open the table, everything looks fine (no "#delete" values). I thought maybe running the Refresh Action might get rid of the deleted values, but it didn't. How can I clear the #deleted's?

Thanks,
Rich

 

[JerryDennison]

Requery the form after running the delete query.

Forms!MainFormName!SubFormName.Requery