Suppressing Append message

[Paul Wagner]

Is there some field or VB command that will suppress "You are about to append 1 record?

 

[maxmangion]

try using DoCmd.SetWarnings false ... don't forget to set them back to true.

 

[Paul Wagner]

Yes Maxmangion, that was it. Thanks! Having people help you who know it is so much more effective than reading a book!

 

[maxmangion]

you're welcome, i'm glad that you sorted out the problem

 

[Rich]

You could also just use the .Execute method, I believe it's faster too