How can I rurn that warning "You are about to append x amount of records......" off and on with code

I think it is something like:

setwarnings = false or something


thanks in advance...

Jerry

DoCmd.SetWarnings (False)
Make sure to turn them back on at the end of your sub.