aMack,
In addition to Steve's response...
Try...
Office Button/AccessOptions/Advanced
and uncheck ActionQueries, to turn off all Warnings.
--
hth
Al Campagna
Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."