Two Recordsets, search field in (1) for values from (2)

[hondurab]

I'm not sure how to go about converting an existing function to use a list of search values from an additional, new recordset. It presently opens one (1) recordset and searches a memo field for values that match a certain format (& tallies, using arrays). I want to, instead, get names from a second table (2) and search for these names in the memo field of all the records in the first recordset.

How do I manage two open recordsets? Can I just grab a list from the new recordset and run through this list?

Obviously I need some big clues! Thanks for any help.

 

[TTThio]

Hi,

I think it is possible to open as many recordset as you want.
If you'd like to use 2 recordsets to find values, the logic should be like below

First, set rstA = "Select Names from TableA"
Second, set rstB = "Select Memo from TableB Where Names = " & rstA("Names&quot

Is this what you mean? It first builds a recordset that collects Names from TableA
Then based on the value, it builds another recordset that collects Memo records.

Hope it work.

Tin Tin