I'm afraid I don't really understand your question. You are mixing terms in a way that makes it hard for me to follow. How do I filter a Recorset based on a different table? That sentence doesn't make sense to me.
Do you mean based on a different Recordset?
If you filter a Recordset, that recordset has to have a SQL statement that includes any tables you would filter in it. You can't filter a Recodset with a value from a table that the recordset doesn't have included in the recordset.
I'm not sure what you are doing, but the answer is to either add a join to the Recordset so that it has the table and columns you want to filter by, or to create another recordset to get the values you need and use that recordset to filter the next one based in its returned value.