Delete Button

[jon2371]

Hi Experts,

i have a form and i need to create a button in a form to delete a record, do you have a sample form for this.


thanks,
Jon

 

[YNWA]

There is a wizard build into design view of your form.

Find the Button icon, click it and draw a button, then the wizard pops up, go through the selections and you should see Close Form, select it, OK, name it etc.. and OK.

Done.

 

[ersocia]

There is a wizard build into design view of your form.

Find the Button icon, click it and draw a button, then the wizard pops up, go through the selections and you should see Close Form, select it, OK, name it etc.. and OK.

Done.

he was asking for a button to delete a record, not close the form.

create a button, and in the wizard select the "Record Operations" category, and choose "Delete Record" from the right hand list box.

 

[jon2371]

Thanks, i need to warned the user before deleting the record...where do insert the msgbox, or do you sample vba code for delete button.

 

[YNWA]

Thanks, i need to warned the user before deleting the record...where do insert the msgbox, or do you sample vba code for delete button.

This is my code for when the user select the Quit Database button

Private Sub cmd_Quit_Click()
On Error Resume Next
If MsgBox(" Close Current Database?", vbYesNo + vbQuestion, "System Message") = vbYes Then
DoCmd.Quit
Else
Cancel = True
End If
End Sub