djscott242 said:
If I delete a record how can I change the options to prompt me a warning
before deleting?
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.
