How to bypass the confirm-update form for an update query

R

RT

Hi,

In the event click of a command button, I run an update query. Is there a
way to run an update query without user confirmation, YES or NO?

TIA,
RT
 
O

Ofer

Use the set warnings to false

docmd.setwarnings False
Docmd.openQuery ""
docmd.setwarnings True ' Don't forget to set it back to true
 
Top