=========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/