suppressing alert messages

[tvt]

Hi,

I set a string variable equal to my "insert" query and run it with:

DoCmd.runSQL myStr

Everything works fine but there's alway an alert message that pops up
telling me that i'm adding a record. Is there anyway to suppress it? I know
in Excel it would be something like:

Application.DisplayAlerts = False

Thanks for the help!

T

 

[Steve Schapel]

T,

DoCmd.SetWarnings False
You should put a DoCmd.SetWarnings True line afterwards.