RECORDSETCLONE ISSUE HELP (1 Viewer)

[sbornstein1]

I have a form that I changed from a recordsource to a recordset On_Open. The code line is:
Set Me.Recordset = rs

When I call a function to complete a find for a bookmark I set the recordset to recordsetclone. It used to work when I was using a recordsource as the bound query. Now ont he following line I get a "Active X component can't create object"
Set testrs = Me.RecordsetClone

Any idea why and what I can do? thanks

 

[charityg]

In my experience, I've found that I can't use the recordsetclone property unless my form is based on a table or a saved query.