On a subform, I have deletions enabled and a prompt if they try to delete an entry that asks if they are sure they want to delete it.
The code works, but it will pop up twice when asking.
Answer = MsgBox("Are you sure you want to delete this Asset History entry?", vbYesNo + vbQuestion, "Delete Entry")
If Answer = vbNo Then Cancel = True
Exit Sub
The code is as above, but it will run twice each time you say no. As in, it pops up, you click no, then it pops up again, and if you click no it goes away and doesn't delete.
Any info on why this happens twice even though I have the Exit Sub in there?
The code works, but it will pop up twice when asking.
Answer = MsgBox("Are you sure you want to delete this Asset History entry?", vbYesNo + vbQuestion, "Delete Entry")
If Answer = vbNo Then Cancel = True
Exit Sub
The code is as above, but it will run twice each time you say no. As in, it pops up, you click no, then it pops up again, and if you click no it goes away and doesn't delete.
Any info on why this happens twice even though I have the Exit Sub in there?