Delete Confirm Message Not Appearing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Thanks Steve. I will give that a shot.

Steve Huff said:
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
Click to expand...
 
Back
Top