Is it possible to combine FindFirst and the InStr() function to identify partial matches between records in two different DAO recordsets?
I was thinking along the lines of something like...
If InStr(rst("AllNames").Value, rst2("OneName").Value) > 0 Then....
where AllNames is a long string containing multiple names and OneName is a single name.
I've tried a number of different variations of this including ones that first assigned two recordset values to string variables but in every case errors occurred. Maybe because I'm exceeding Findfirst's capabilities?
I was thinking along the lines of something like...
If InStr(rst("AllNames").Value, rst2("OneName").Value) > 0 Then....
where AllNames is a long string containing multiple names and OneName is a single name.
I've tried a number of different variations of this including ones that first assigned two recordset values to string variables but in every case errors occurred. Maybe because I'm exceeding Findfirst's capabilities?
