How can I get it to prompt a warning before deleting a record

  • Thread starter Thread starter djscott242
  • Start date Start date
D

djscott242

If I delete a record how can I change the options to prompt me a warning
before deleting?
 
djscott242 said:
If I delete a record how can I change the options to prompt me a warning
before deleting?
Click to expand...


That depends on how you're doing it. By default, Access does warn when a
user deletes a record via a form. If you're not seeing that, check your
options to make sure "Confirm ... Record changes" is checked. Also make
sure that you don't have code that turns warnings off:

DoCmd.SetWarnings False

without always subsequently executing a statement that turns them back on
again:

DoCmd.SetWarnings True

It's also possible to write your own warnings, to be displayed in place of
the built-in Access delete warning, using the form's BeforeDelConfirm event.
See the help file for details.
 
Back
Top