Delete Record Prompt

[jcruzAME]

On a subform that displays records I have record selectors enabled in case they need to delete one.

Currently I have a prompt in OnDelete (I'm not sure if this event is too late to cancel) that asks do you want to delete this record. If yes, it deletes. If I click no, it does Exit_Sub but the record is still deleted.

Is there somewhere else in the code I should prompt this? It seems like by the time it gets to OnDelete it is already deleted.

 

[bob fitz]

Cancel = True

in the Form Delete event will stop the delete.

 

[jcruzAME]

Thanks!

Now it seems to be going through OnDelete twice and the message box is popping up twice. What would cause this?