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
George Nicholson - 17 Nov 2005 19:04 GMT
One possible answer in access.formscoding

Signature
George Nicholson
Remove 'Junk' from return address.
> 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
[quoted text clipped - 13 lines]
> FinalAns tblNo2 5
> FinalAns tblNo3 5