Delete Confirm Message Not Appearing

[Williams]

The confirmation message for deleting records does not work consistently.
Sometimes the user is prompted to confirm the deletion. Other times the
record is deleted right away without confirmation. The confirmation check
boxes are selected for "Confirm Record Changes", "Document Deletions" and
"Action Queries" in the Tools, Options dialog box. There is no code in the
before Delete or After Delete actions on the form. Any suggestions for
forcing the confirmation box to consistently appear?

 

[Steve Huff]

Search all the code in the database to see if you find the following line:

DoCmd.SetWarnings False

If they didn't set it back to true then when that fires it would turn off
all Warnings. It might be some other event that is doing it then when they
go to another location it's still turned off.

Steve Huff

 

[Williams]

Thanks Steve. I will give that a shot.

Search all the code in the database to see if you find the following line:

DoCmd.SetWarnings False

If they didn't set it back to true then when that fires it would turn off
all Warnings. It might be some other event that is doing it then when they
go to another location it's still turned off.

Steve Huff