Desperate Help Required!!!!

[ahson88]

I need to make a button in a form which allows you to delete the record. what expression shall i use?? i am using access 2000. any help??

 

[directormac]

sing along...

All together now: "We're off to see the Wizard..."

 

[ahson88]

i have tried that but it doesnt seem 2 work..

 

[pdx_man]

The Control Wizard will build this for you when you create a button. Be sure to have the Control Wizard selected when making the Command Button Control. It looks like a wand with pixie dust on the left side of the tool bar. Follow the wizard through.

 

[pdx_man]

It will generate code that looks like this:

Private Sub Command42_Click()
On Error GoTo Err_Command42_Click


    DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
    DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70

Exit_Command42_Click:
    Exit Sub

Err_Command42_Click:
    MsgBox Err.Description
    Resume Exit_Command42_Click
    
End Sub