Suppress warning msg

[BobbyS]

I have an update sql statement being run in Access.

When the update runs, I don't want the message prompting the user to update
or not update. I want it to update without user interaction.

How can I do that?

Thank you.

 

[Douglas J. Steele]

Either issue a DoCmd.SetWarnings False before you run the query (and
DoCmd.SetWarnings True after), or use the Execute method of either the
Database or QueryDef object. (Of course, given what newsgroup you've posted
to, the latter may not be possible: those are DAO objects, and ADPs don't
support DAO)