suppressing alert messages

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
T,

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