Get rid of the "Update Messages"

[hewstone999]

I have a button that inserts values into a table. But every time is dose this, a update message appears. How can i change this so this doesn’t appear? Is it something to do with the security settings? or is there some code which automatically clicks yes? - I want to min user involvement.

Update Message

********************************************************************************
Your about to update 15 row(s)

Once you have clicked yes, you can't use the undo command to reverse the changes.
Are you sure you want to update these records?

YES/NO
********************************************************************************


Kind Regards
Richard

 

[gemma-the-husky]

either surround the statement with

docmd.setwarnings false
and
docmd.setwarnings true

OR

use currentdb.execute myquery rather than

docmd.openquery myquery