[email protected]

  • Thread starter Thread starter Syd
  • Start date Start date
S

Syd

I built a delete query that pops up after the query is run
behind the scenes. Is there a way to avaoid this post run
delete query from popping up after it's run? Other queries
which run during the same event trigger do not pop up
after running.

Thanks
 
Syd

Are you saying that a "message box" pops up when you run a delete query? I
don't understand how a query "pops up" after you run that query.

If it's a message box you're trying to avoid, you can run the query from
code (or a macro), and add the SetWarnings command to turn off warnings.

NOTE: If you don't remember to turn the warnings back ON afterwards, Access
can be doing all kinds of things without you ever being told -- use
SetWarnings to turn the error messages back ON!

Jeff Boyce
<Access MVP>
 
Actually, the resulting query in a datasheet lay out pop
up. You see, I'm trying to delete a portion of data in a
table. After the query is run using the Setwarnings
False/True settings. The resulting query pops up in the
active screen mode.

Any ideas?
 
Back
Top