Preventing queries opening in datasheet view

[Tim Long]

Hello, I have a procedure (Access 97) which runs (from a command button on a
form) a number of queries using DoCmd.OpenQuery (with SetWarnings set to
False). The first five queries run without displaying the results in a
datasheet, but the sixth query is a union query and from that point onwards
every query, whether it's union, select, update or append, opens up in
datasheet view.

I would like these queries to work in the background without opening up into
datasheet view but don't know how to prevent that. Any help would be much
appreciated..

 

[Ofer]

When you run a select query it will display the data in a data sheet view,
only action queries (append, update, create) wont show the data, because
there is no data to display.
What are you trying to do with the union query?