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
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