is it possible to eliminate the message that shows up after runing an update
query??
thank you
Yes; if you're running the query from a Macro or from VBA code, put a
line to set SetWarnings to False before running the query. Be sure to
put Setwarnings back to True afterward, or you'll turn off ALL warning
messages for the rest of the Access session.
John W. Vinson[MVP]