"Delete Record and Close" Button

[Uvuriel03]

I'm trying to create a button that will delete the current record and close the form using Macros. (I'm terrible at VBA--if anybody knows a good tutorial site, please, link away!!)

If I could get some help with what actions to use for the macros, I would really appreciate it!!

Thank you!

 

[Mike Vytal]

Hello Uvuriel,

First, create a new macro. Under the action column on the 1st line, type 'RunCommand'. Look down where you'll find a command line. Enter DeleteRecord. Then on the 2nd line, type 'RunCommand'. Enter Close on the command line. Save your Macro whatever name you chose (DeleteClose).

Open your form in design view and create a button. Open up the properties and on the 'OnClick' event, enter the Macro name, and you're done.

Note you will get a delete record confirmation. If you want to avoid this, insert a row in your macro above the first line and enter 'SetWarnings'. Look below and make sure 'Warnings On' is set to No.

Hope this helps...

 

[Cosmos75]

Maybe this will help you get started.

Form - Editing Records (Form Buttons - Add, Delete, Save, and Undo changes)

For the close button (button named cmdClose)

Private Sub cmdClose_Click()
On Error GoTo ErrMsg

    DoCmd.Close

ExitHere:
    Exit Sub

ErrMsg:
    MsgBox Err.Description
    Resume ExitHere
    
End Sub