How to turn off the alert for action query in Access 97?

[jinglin]

I went to Tools, Options and then choose Edit/Find tab. I unchecked the mark for the Action Queries in the area of Confirm section. But when my actions are run, an alert message still pops up? Can you tell me why?
Thanks!!

Jinglin

 

[Blorf]

I dunno, but you can use setwarnings to no in a macro to solve the problem.

ChaZ

 

[jinglin]

Thanks for info.

Actually in the form_load event, I used:
docmd.setWarnings false
and in the form_unload event:
docmd.setwarnings true 'in order to reset it back to on

and they worked.

 

[Blorf]

Cool.