stored queries

[philfer]

What is a stored query?

Is it just a query that you create in design view that is saved in the db (and thus compiled) that you can execute in vba with :-

DoCmd.OpenQuery

or is there more to it?

Thanks
Phil

 

[neileg]

Yes, with the extension that you may have created the query in SQL view instead of design view.

 

[gemma-the-husky]

and just to confrim

each time you open a query it gets all the information afresh

you dont need to expressly "update" the query.

--------
if you have form open based on the query, and you want to refresh the data, you can explicitly issue the command (in code) me.requery which does redo the query, in case it has changed