You can temporarily disable the modal warning messages displayed by Microsoft Access while a macro or Visual Basic procedure is running, or enable them again by carrying out the SetWarnings action in the macro or procedure.
Show or hide warning messages by using a macro
Show or hide warning messages by using Visual Basic for Applications