CCLINT / other Guru's- ADO Recordset Clones

[Trudye]

This thread is for CCLINT and other Guru's or anyone who happens to know:
I read the following answer (from CCLINT) in another thread, the topic was doing a FIND on an ADO recordset:

In ADO, after using the Find method, check the .EOF property. If it is True, then there were no records found between the record where the search began and the end of the recordset.
You could easily create your own NoMatch property and/or Find Method with a return value, easiest by creating a recordset Clone and doing the record search there, and using the Bookmark property to set the main recordset Bookmark to the RS Clone's Bookmark, if a record was found


My question is how do I create a recordset clone? I am using ADODC as my recodset. How do I make a clone of it so that I can search the clone and set bookmarks. Also how do I set match/nomatch properties?

Thanks much
Trudye

 

[Trudye]

I think I found the answer to my first question:

Set rs = Me.RecordsetClone

Will this work with ADODC1? Can I now do a .match/.nomatch? How do I set the props for these?

Thanks much
Trudye

 

[Trudye]

I think I found the answer to my second and third question:

If Not rs.EOF Then ADODC1.Bookmark = rs.Bookmark

Am I at least in the ballpark?

Thanx
Trudye