how do you run a query from VBA code

Hi

simple question for you.
how do you run a query from VBA code. I normally write the sql statement out in VB and have never run a query before.

the query is called query2 , do I put a command button on a form and type run query2 in the onclick event. Easy when you know how !

cheers guys
Locutus

I believe

opendb.QueryDefs("queryname" or index#).execute

will do what you want.


DerFarm