Silence update query 1

[jaxflorida]

Does anyone know how to run an update query from a macro (or any other workaround)where it doesn't stop the process to say "You are about to run an update query that will modify data in your table" and then "You are about to update 3 row(s)"? In other words, I want the process to just happen when I click the button assigned to the macro.

Thanks for any help you can offer!

J

 

[JaneC]

You will need to use SetWarnings in the macro.
Once before the query and once afterwards to turn them back on again

HTH

JC

 

[jaxflorida]

Thank you very much!

J