Remove information about an error that is stored in the MacroError object. (Access 2010)
Syntax
DoCmd.ClearMacroError
If the OnError action has been used to suppress error messages, you can use the information stored in the MacroError object in a condition or a custom error message.
By default, when an error occurs in a macro, information about the error is stored in the MacroError object, the macro stops and the error information is displayed in a standard error message.
After an error has been handled, the information in the MacroError object is out of date, so it is a good idea to clear the object (error no, description, macro name, action name, condition, and arguments) using the ClearMacroError action.
Example
Docmd.ClearMacroError
“Always assume incompetence before looking for conspiracy” ~ Niccolo Machiavelli
Related:
OnError macro action