Multiple open run queries

[Oscar]

I have a stack of open queries in a macro. At the moment all the queries open up even if they have no results. Is it possilbe to have as part of the macro, to close that query if no results.

Your help would be much appreciated.

 

[namliam]

this is posible, tho it would mean opening the query as a recordset in order to get the record count (if =0 then dont open to show) Might not be posible in a macro, but is in VBA.

If you make forms of those queries, you can open the form only and On Open of the form check me.count ( or something simular ), if 0 the me.close.

Regards

The Mailman