I am using an Access 2k adp, and am trying to assign an ado recordset to a subform.
Here is the code that I am using:
dim rsx as adodb.recordset
Set rsx = New ADODB.Recordset
.ActiveConnection = CurrentProject.Connection
.CursorType = adOpenKeyset
.LockType = adLockOptimistic
.Source = "select * from products"
Set Me.sfmSearchAllResults.Form.Recordset = rsx
.ActiveConnection = Nothing
I get the error:
7874 : Microsoft Access can't find the object 'Recordset.'