Update Query Without Confirmation Box 1

[SmokingCrater]

Is it possible to execute an update query without requiring the user to hit "Yes" to that pop up box that asks if they really want to update N records? I want to do some updating in the background after one thing changes and I don't want the user to have to hit "Yes" to the updates. It doesn't appear that the DoCmd.RunSql gives me that functionality.

Thanks.

 

[Databaseguy]

Using VBA or a macro, turn off the SetWarnings method of the docmd object.

docmd.setwarnings = false

 

[SmokingCrater]

Thanks. That's exactly what I needed.

One minor correction tho, it's
docmd.setwarnings(true)
docmd.setwarnings(false)

The're functions not properties.

But thanks for pointing me in the correct direction.