Warning Boxes

[hays]

This is fairly trivial, but in a subroutine I have:

DoCmd.RunSQL "INSERT INTO..."

This leads to a warning box ("You are are about to append x row(s)&quot popping up. Since this sub will be run a fair number of times, is there anyway for me to bypass this box, or code in an answer? Thanks in advance.

 

[kathryn]

Look at the SetWarnings property in the Help files. Kathryn

 

[hays]

Thanks.