i have a form with subform.
subform in datasheet view
when i select a row of the subform & click the cmdbutton(delete)
access standart msgbox shows. but i want my msg
i have a form with subform.
subform in datasheet view
when i select a row of the subform & click the cmdbutton(delete)
access standart msgbox shows. but i want my msg
Try:
Private Sub Form_BeforeDelConfirm(Cancel As Integer, Response As Integer)
'Suppress default Delete Confirm dialog box.
Response = acDataErrContinue
MsgBox "some text here", , "Delete"
End Sub
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Also, in Help, read about the "Delete Event" (not OnDelete property) and the "BeforeDelConfirm Event" (not BeforeDelConfirm Property).