Look up
DoCmd.SetWarnings False
in Access help - that will turn your warnings off
be sure to turn it back though
I think there is a UI version under tools options too.
cheers
Simon


--
Simon Murphy
------------------------------------------------------------------------
Simon Murphy's Profile: http://www.excelforum.com/member.php...o&userid=26538
View this thread: http://www.excelforum.com/showthread...hreadid=398016