Subquery?

Hello,

I have a 3-table query that gathers it's criteria from a Criteria Selection
Form (This works fine). After I get the results from this query, I would
like to do another query that uses the result from the first query to compare
to a table of all possible choices to see what might not be matched. I can
get this to work by creating the 2 queries separately. The problem is that I
want the final result to be the record source for a report when I click on
the preview button from the selection form.

I have tried to copy the SQL, but my dilema is that I need to pass the
criteria to the first query, then from that query result create another SQL
string to find unmatched, and to throw a wrench in it, use a piece of
criteria from the first query.

I think I might have to create a temp table and use that, or can I use
subqueries?

Any help would be appreciated.

Thanks.