When you disable setwarnings in your code or in a macro and forget to enable
it again, any changes to forms are automatically saved without prompting you.
Push ctrl+g to open the immediate window and paste this, then hit the enter
key:
DoCmd.SetWarnings True
Now they're back on. Search through your code for DoCmd.SetWarnings False
and remove these lines of code. You don't need them. Use the dbfailonerror
argument for the execute method on action queries, and you won't get any
popup messages during action queries unless something fails and your error
handler uses a message box to tell you.
Chris
Microsoft MVP
