Two Delete Message boxes

[Mansfield]

When I delete a record I get one message box (The one I have programed in) and once I click ok another one pops up telling me that I am "about to delete a record, am I sure?" How do I get rid of the second one. Any help would be much appreciated.

 

[Neal]

You can get rid of those warnings by going to Tools/Options and the Edit/Find tab. Uncheck the ones you want turned off:
Record changes
Document deletions
Action Queries

 

[Fornatian]

Alternatively use:
Docmd.Setwarnings False
...Actions,Deletions,Updates go here
Docmd.Setwarnings True

The advantage is that you control when the warnings show/don't show.

ALWAYS ENSURE YOU INCLUDE

'DOCMD.SETWARNINGS TRUE'

TO ENSURE YOU ARE TOLD ABOUT OTHER ACTIONS AND ERRORS AFTER THE EVENT.

Ian