Confirm message dispaly

[Gina]

You need to a DoCmd.SetWarnings False before and a
DoCmd.SetWarnings True after the query. I am assuming you
are using a button or soemthing to run this query...

DoCmd.SetWarnings False
DoCmd.RunQuery "QueryName"
DoCmd.SetWarnings True

Hope that helps...