Turn off delete record message using code.

[Guest]

I have a button on a form that contains a subform. When I click on the button
the selected record on the subform is deleted from the underlying bound
table. Is it possible to stop the message box appearing, advising that a
record is about to be deleted, using code for this procedure only. Ie I still
want to be advised if I run other delete queries within the application.

 

[Gina Whipp]

Greg,

DoCmd.SetWarnings False 'turns off messages
***Put your delete sequence in here***
DoCmd.SetWarnings True 'turns messages back on

 

[Guest]

Thanks Gina!

Greg,

DoCmd.SetWarnings False 'turns off messages
***Put your delete sequence in here***
DoCmd.SetWarnings True 'turns messages back on


--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

 

[Gina Whipp]

Glad to help, thanks for posting back!