Hi,

I am using Microsoft Access 2000, and would like to run a select query (not select..into) from vba instead of making a constant query.

Is there something similar to the DoCmd.runQuery method that works on select queries.

It is important because I am generating the Select and From clauses of the SQL statement using VBA, and would like to run that exact statement over multiple tables.

Any help would be appreciated.