Hello, I have a continous form that shows all users in this address book app I am building. I put a delete button next to the person's information and it shows up continuously. But when I press the delete button I get an error beep and the record is still there. Here is my code:

Private Sub delteIcon_Click()
On Error GoTo Err_delteIcon_Click



    DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
    DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70
    DoCmd.Close
     DoCmd.OpenForm "ViewAll"

Exit_delteIcon_Click:
    Exit Sub


I can do this when I only view one record at a time but can I get it to work on the continuous form? By the way, I saw that someone had a problem with the record showing #DELETED after they hit the delete button on a record. I was able to fix this by closing the results form and reopening it:

DoCmd.Close
     DoCmd.OpenForm "ViewAll"

Thanks for the help in advance

Instead of closing and reopening, how about simply...

Me.Requery


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division