How do I shut of Delete Confirm? 3

[MarshaP]

I want to delete a record with VBA in Access 2000, but I don't want the user to have to confirm it. I tried using

Application.SetOption "Confirm Document Deletions", False

before the delete and then setting it back to true afterwards, but I am still getting the confirmation message. When I run it through debug, I don't get the message at all, even without the set option. Any suggestions?

 

[Rohdem]

DoCmd.SetWarnings False

and

DoCmd.SetWarnings True Mike Rohde
rohdem@marshallengines.com

 

[nomus1]

If you want to eliminate this message on all delete querries you could
TOOLS
OPTIONS
EDIT/FIND
and Turn off the confirm edit querries.