DoCmd.SetWarnings False


reset it after running your procedure

DoCmd.SetWarnings true