I'm using VB6 and Access 97 with ADO

How can I get VB to run a query that's already stored in Access and pass it a parameter and then give the result that it gets back to a recordset.

------------------
Thanks in advance for any help provided.