How To Stop Vb Warning While Deleting A record

[Malik via AccessMonster.com]

Hi
I Have a Form With A delete Button And The Code is

DoCmd.RunCommand acCmdDeleteRecord

When Delete Button is pressed on , The Vb Confirm that with YeNo MsgBox.

How Can i stop its Confirmation MsgBox

Thanks.

 

[Linq Adams via AccessMonster.com]

DoCmd.SetWarnings False
DoCmd.RunCommand acCmdDeleteRecord
DoCmd.SetWarnings True

 

[malik via AccessMonster.com]

DoCmd.SetWarnings False
DoCmd.RunCommand acCmdDeleteRecord
DoCmd.SetWarnings True

Thanks So Much

 

[Allen Browne]

Are you sure you want to delete records without any warning? Even if many
records are deleted at once? And even if cascading deletes are wiping
records from other tables as well?

You can use the BeforeDelConfirm event procedure of the form to suppress the
message for one form.