Removing the delete prompt.

[botts121]

I am interested in deleting a record but I don't want the auto prompt to come up. I just want it to delete the record without me having to hit "Yes". Anyone have any thoughts on how to accomplish this?



Thanks in advance,

Matt

[pdouglas]

Tools --> Options -- Edit Find
There are options for confirming changes and deletions.

(Some versions may vary.)

[RuralGuy]

in code if you use CurrentDB.Execute you do not get the warnings.

[botts121]

hey pdouglas, how can i find that "Edit Find" in Access 2007?

Thanks,

Matt

[pdouglas]

Matt
I haven't had any experience with 2007.
I would assume there would be something similar in the Options dialog box. (That is where it is on 2000, 2002/XP, and 2003)

You get to it by going Tools --> Options... and having the Options Dialog box come up. On 2003, there is a tab "Edit/Find".