I have a form with one text field called Number.
I am trying to set the forms recordset property to that of a rs that I created. Here is the code:
Private Sub Form_Open(Cancel As Integer)
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
rs.CursorLocation = adUseClient
rs.Fields.Append ("Number"), adChar, 1
rs("Number") = "1"
rs("Number") = "2"
Set Me.Recordset = rs
I am getting a 7965 error: The object you entered is not a valid recordset property.
Can someone she some light on this for me?