Alert user before allowing record updates or deletions
Posted on 2016-10-18
I have an Access form that I added an Update (i.e. Save record) button to and a Delete record button. I used the Command Button Wizard to create them, so the on click events have embedded macros instead of event procedures, which is throwing me off.
I'd like to give the users a chance to change their mind when they attempt to update or delete a record.
How can I accomplish this? If the user presses the Delete button for example, I'd like to have a vbYesNo message pop up and ask "You are about to delete the displayed record. Are you sure you want to delete it?"