load query results into ado recordset

[spleve]

I want to loop through query results in vba. This query is in the
same access db as the vba module. I thought I wanted to load the
query results into an ado recordset, but cannot find the syntax. I
can re-create the query in vba, substituting the wildcard character
"%" for "*", and that works, but is not what I want.

I want to be able to manipulate the query in access, then process the
results in vba, one row at a time.

Any suggestions?