Karl,

 I am setting the warnings off and then back on again at the end of the
Event. And I am very happy with the warning messages not popping up, as I
know it would confuse the end-user. But is there a way to allow(code) to see
more severe messages? Like a error message when the user is trying to add
duplicate records? I am wondering if there are a few select messages that we
really do want to see, and that access considers them just warnings, while
some of us would consider them error messages (duplicate keys, etc..). I have
been searching help and the discussion group to see if there are any
options/message severity levels that we can opt for when turning off
messages. I am worried that access may consider my query to copy a table to a
backup table name, that fails a warning message and then continue in the
event/or macro to execute the next query and update my table, and then clear
out my input table source. And I think you can see what I am trying to say...
 Maybe I don't understand the difference between a warning and a error?