[AccessD] How to set a value from one recordset as a parameter for a select statement that is source to another recordset

Is there a way to do this? I have select distinct COID statement as source
for a recordset that I'm looping through, and want to use the distinctly
selected COID as a parameter in a select statement that is recordsource for
another recordset that I'm using to create Excel files.

Thanks in advance for any help!

Jim