Delete confirmation dialog box

[Bonhomme Septheure]

Hi,

Is there a way in a form's BeforeDelConfirm or AfterDelConfirm event to detect the response to the confirmation dialog box Access displays when a user deletes a record?

I'd like to force a subform to requery if "yes" is chosen in the dialog box.

Thanks!

 

[mdlueck]

You check the return code from a MsgBox, and if the button was clicked to "Rollback / Cancel" then you do

Cancel = True

Here is a link:
http://msdn.microsoft.com/en-us/library/office/bb238523(v=office.12).aspx

 

[Bonhomme Septheure]

Thanks for replying so quickly!

I actually found a solution on the following link regarding the Form.AfterDelConfirm event: http://msdn.microsoft.com/en-us/library/office/ff193473.aspx

There's an example there of using a select case statement to determine whether the deletion occurred or whether the user cancelled it.

I shouldn't have be using the BeforeDelConfirm event in the first place.

Thanks!