Solved Form After Delete Running after selecting No

[dgreen]

What would cause my code to trigger the Form_AfterDelConfirm when I select NO on the popup confirming if I want to delete these records.

Visual of the subform and button (red circle) being pushed.

Here's the a snipit showing where the code goes to immediately after the NO selection.

I am able to stop the action with my click selections, but I would rather that the code not even run since I said no on the earlier selection.

 

[CJ_London]

because it is after the delete confirm popup has closed - the status tells you whether the record(s) are deleted or aborted - see this link

Form.AfterDelConfirm event (Access)

Office VBA reference topic

docs.microsoft.com

so you need to modify your code depending on status

 

[theDBguy]

Hi. As CJ said, the event fired because it was supposed to. But, whatever happens when it does is up to you.

 

[dgreen]

Modified the code with the select statement and removed the warnings setting. Something new.