M
Martin
I've got some fairly involved validation code run by my form's Before Update
event that tells the user if they've not typed some essential data and asks
if they want to now fill it in (by way of the MsgBox function).
The annoying thing is that if they decide to delete the record having left
some of the vital fields empty, the first prompt they see is my message box
which they then have to click through before getting the familiar delete
record confirmation message. Is there any way to capture the fact they're
deleting so that the Before Update event can be sidestepped? The form's
Delete event runs after the Before Update so I can't use this.
event that tells the user if they've not typed some essential data and asks
if they want to now fill it in (by way of the MsgBox function).
The annoying thing is that if they decide to delete the record having left
some of the vital fields empty, the first prompt they see is my message box
which they then have to click through before getting the familiar delete
record confirmation message. Is there any way to capture the fact they're
deleting so that the Before Update event can be sidestepped? The form's
Delete event runs after the Before Update so I can't use this.