how to listing compared string in two open recordset.
i have problem using "ObjRst2.Find Criteria" where Criteria is string 
value from the ObjRst1 to find string in ObjRst2. criteria query cannot 
find exactly string. i have trying used "inst" command but still going 
wrong.

example:

ObjRst1                  ObjRst2
Field                    Field  
-----                    -----  
"John   "                "   John    "  'string in the middle field
                                 
                           
anyone can help?

> how to listing compared string in two open recordset.
i>  have problem using "ObjRst2.Find Criteria" where Criteria is string 
v> alue from the ObjRst1 to find string in ObjRst2. criteria query cannot 
f> ind exactly string. i have trying used "inst" command but still going 
w> rong.

> example:

> ObjRst1                  ObjRst2
F> ield                    Field  
-> ----                    -----  
"> John   "                "   John    "  'string in the middle field
 >                                 
 >                           
a> nyone can help?


Are the spaces important?? Perhaps use Trim function and Like in criteria.

For example:

     ObjRst2.Find  "Field Like '%" + Trim(ObjRst1("Field")) + "%'"

Good luck