Set warnings on/off in queries

J

JOM

by pressing one button am running 3 update queries that would update 3
different fields in 3 different tables at once and would not like to the
warning that you about to update 3 records three times, however I would like
the user to be informed that the following [Fields] in the following [tables]
with [countRecords] were updated.
I have set the warnings as DoCmd.SetWarnings False.

E.g, Should be like
Fields Table Records (This line is just an illustration can be
ignored)

FinalAns tblNo1 5
FinalAns tblNo2 5
FinalAns tblNo3 5
 
Top