import an access query into a recordset

[scottian]

I have a macro that imports an access table into a recordset. It works great, but id prefer if i could use one of the queries instead. When i set the recordset variable to the name of the query i get an error :-
Microsoft JET Database Engine: Invalid SQL statement; expected 'DELETE','INSERT','PROCEDURE','SELECT' or 'UPDATE'. Can anyone tell me why it wont let me connect to a query

Ambition..........If you dont use it, you wont lose it