Delete button on continuous form

[jonwolds]

Hi,

I want to create a delete button which appears against each record on a continuous form. The user can then click the delete button and it'll delete the row that it sits against.

Not sure how to do this

Thanks
Jon

 

[ZmrAbdulla]

This code works fine in my database. Put the command button in the details section of the form

Private Sub cmdDelete_Click()
On Error GoTo Err_cmdDelete_Click
    DoCmd.RunCommand acCmdDeleteRecord
Exit_cmdDelete_Click:
    Exit Sub
Err_cmdDelete_Click:
   Select Case Err.Number
   Case 2046
    MsgBox "You can't delete a blank record"
   Case Else
    MsgBox Err.Description, vbInformation, Err.Number
   End Select
    Resume Exit_cmdDelete_Click    
End Sub

Regards

Zameer Abdulla

http://www.geocities.com/zameerabd/

http://www.mtkhoory.com

 

[jonwolds]

Thanks very much, I'll give it a shot.
Jon