Warning user of record deletion

Hi,

I need help creating a dialog box. Basically I have a delete record button in my DB, but when clicked, I want a dialog box popping up saying something like "Are you sure you want to delete this record?"

So Im guessing Im going to need some sort of "IF" statement when the button is clicked...but im lost since I dont know much about programming. If anybody could help I would appreciate it.

Thanks,

Rob

re: Warning user of record deletion

You may use something like this:

re: Warning user of record deletion

Line #2 of that code needs to be changed from

vChoice = MsgBox("Are you sure you want to delete?", vbQuestion, "Confirm")

to

vChoice = MsgBox("Are you sure you want to delete?", vbQuestion + vbYesNo, "Confirm")

When vbQuestion is used by itself, a single "Okay" button appears, so the user has no real choice. And since clicking "Okay" doesn't return vbYes, the code will branch to the Else statement and the deletion will never happen.

The Dim statement, if used, should really be

Dim vChoice as Integer

as that's what message boxes actually return. vbYes is a Constant for 6 and vbNo is a Constant for 7. Fortunately, Access is very forgiving in this, and reads the String 6 or 7 as a number.

Welcome to Bytes!

Linq ;0)>

re: Warning user of record deletion

Thanks both of you. Works just like I want it. Much Appreciated

re: Warning user of record deletion

There is only 1 major problem with the previous approach. What if a User Deletes a Record via the Menu Bar or Toolbar? The following code, placed in the BeforeDelConfirm() Event, will cover all contingencies:

re: Warning user of record deletion

It would be very good to have a warning through using the toolbar or menu.

The code doesnt seem to work though?

re: Warning user of record deletion

What exactly is the error you are getting?

re: Warning user of record deletion

No Error, it just deletes the record without asking a dialog box.

Its like its not executing Form_BeforeDelConfirm. The code is there but not being used

re: Warning user of record deletion

The code is sound and fully functional. There are only 3 reasons that I can think of as to why it isn't working for you:

1. The code is not in the BeforeDelConfirm() Event Procedure of the Form.
2. The code is in the correct Procedure, but it is not the exact code that I had previously posted.
3. The words [Event Procedure] do not exist in the Before Del Confirm Property of the Form.