ACCESS Programming DELTE problem
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
|