how do you run a query from VBA code

[locutus]

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