Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Delete button no longer prompts before deleting

Status
Not open for further replies.

pmo

Technical User
Jan 15, 2001
76
AU
I have a simple form with a wizard created delete button.
In the past when I clicked the delete button it would prompt prior to deleting.
Now the record is deleted and can't be retrieved if clicked by mistake.
I have checked the options and made sure prompt is checked in there.
Is there somewhere else I need to check.

I am using Access 2000

Wayne
 
What is the code behind the button?

Hope this helps
Hymn
 
pmo, the code behind your button should look like this if it was created by the wizard:

Code:
Private Sub Command112_Click()
On Error GoTo Err_Command112_Click
    DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
    DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70
Exit_Command112_Click:
    Exit Sub
Err_Command112_Click:
    MsgBox Err.Description
    Resume Exit_Command112_Click
End Sub

Judge Hopkins


There are only two rules for success: (1) Never tell everything you know.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top