Coding a msg box to verify user's delete action, etc.

[allis]

I have created a program, with a form where the user can view the records in a database, add, delete, search, update, etc.

When they push the delete button, I have a message box come up asking if they really want to delete that record, to prevent accidental deletion.

How do I code this box so that when they press "No" - it does NOT delete, and when they press "Yes" it DOES delete?


Thanks

 

[ADoozer]

if ure just using a standard messagebox(msgbox):-

If MsgBox("Delete?", vbYesNo, "Delete Me?&quot = vbYes Then
'delete record
Else
'dont delete record
End If

good luck

If somethings hard to do, its not worth doing - Homer Simpson
------------------------------------------------------------------------
A General Guide To Excel in VB FAQ222-3383
The Great Date Debate Thread222-368305
File Formats Galore @

http://www.wotsit.org

or

http://www.filext.com