how to get rid of default messages when running queries 1

[elinorigb]

Hi Again,

This is probably simple, but maybe not. I have some buttons on several forms that run some macros. These macros, in turn, run various update or append queries. While these macros and queries are running, I get several messages, something like
"You are about to modify 43 records. Are you sure you want to proceed?"

My question is, is there anyway I can get rid of these messages, so that the user doesn't have to keep saying OK in order to keep the queries running?

thanks as always

 

[LarryDeLaruelle]

If you want to disable the warnings add a SetWarnings = No before your first action query in the macro;

Make sure you SetWarnings = Yes after the last action query.

Larry De Laruelle