OpenQuery method displays Union Recordset

[bajo71]

Hello,

I have a series of DoCmd.OpenQuery "..." lines which run delete, make-table, append and union queries. All query types but union run 'behind the scenes'.The union recordset however, pops up using the above referenced method.

Is there any way for the union to run without displaying recordset?

Thank you much............Rick

 

[PHV]

any way for the union to run without displaying recordset
An UNION query is designed to merge several SELECT instructions and thus I don't understand your issue ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Golom]

As PHV says, a UNION query's purpose in life is to return records. What's the point of running it if you don't want that to happen?