Suppress "You are about to append 1 row" msg? 1

[solun]

I'm using DoCmd.RunSQL (strSQL) to add rows to a table. I want it to not notify me that it's appending a row - it's really irritating and the table is specifically for these added rows. How do i suppress that warning?

Thanks,

Heidi

 

[earthandfire]

DoCmd.SetWarnings False
DoCmd.RunSQL (strSQL)
DoCmd.SetWarnings True

Hope this helps.