I have an access front. One button named delete, i would like to have a pop up box that display message: Are you sure you want to delete? to make sure the user really want to delete the record. How could finish this in property? Thanks.
Chances are (by the sound of it) you used the Button Wizard to provide a Delete Record button on your Form. In the OnClick event (via the VBE) for the Command Button you can see all the code that was placed there by the wizard.....Because you didn't provide the underlying code for your command button then If you dare, delete it and try this:
Private Sub myCommandButton_Click()
On Error Goto myCommandButton_Error
If MsgBox("Delete Current Record..." & vbCrLf & vbCrLf & "Are you sure you want " & _
"to Delete this Record?", vbExclamation + vbYesNo, _
"Delete Record...") = vbYes Then
Change the items in Red to reflect the name of your Command Button.
Self Taught In ALL Environments.....And It Shows!