=========
REF:
http://www.mrexcel.com/forum/showthread.php?t=355482
=========
It appears the SetWarnings Action is missing when building a new Macro.
Go to the Design Tab, click Show All Actions
—
http://www.anysitesupport.com/access-2007-macros-setwarnings/