create a recordset object from a forms recordset

[clapper62]

I have a form with data I populated with a ADO recordset from SQL server
what I would like to do now is create a recordset object from the data in the form

something like this

Dim rst As New adodb.Recordset
Set rst = Me.Recordset
Set rst = Nothing

this code runs without error
but I dont think it really works
because when I try to do anything with the recordset
such as .sort or .recordcount I get an error

is it possible to do what I'm trying to do?

 

[MajP]

Not sure if it is the issue, but you need to set the cursorlocation to your RST when you create your ado recordset. You set it in RS2.

http://msdn.microsoft.com/en-us/library/office/aa207085(v=office.10).aspx

 

[clapper62]

I tried several different cursorlocations while creating the recordset with no success
and I have spent more time on this than I wanted to so I think I will just create a new
connection to the server and create recordsets with SQL sorted the way I want it displayed

I'm sure you are facing me in the right direction and I thank you for your time and help
hopefully I can revisit this later