How to suppress Update query msg when run in VBA

[VicM]

I want to run an Update query multiple times in VBA accessing fields in a table to insert the 'change from' and 'change to' parameters into the SQL statement. Then use a loop to step thru the 'from/to' table thereby updating multiple records in the main table.
When I run the Subroutine I get the Update message asking if I want to continue.

Is there a way to suppress the message and let the update continue thru the loop? I don't want to click yes for the multiple times I want the query to run.

Thanks for any suggestions,

Vic

 

[SkipVought]

Hi,

Running VBA for what Application?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[VicM]

Oops. Sorry Skip.
Running code in Access 2010.
But the light finally dawned. I only had to put in a DoCmd.SetWarnings False statement, before starting the loop.

Thanks,
Vic