>'the problem is that the recordset is created and 'populated'
>Dim rsMine as ADODB.Recordset
>Set rsMine = DataEnv.dbTss.execute(strSQL)
>
>'then the grid is loaded from this
>Set mygrid.datasource = rsMine
>
>'then the recordset goes out of scope, but myGrid retains the data with out a connection to the recordset. The problem is I need to be able to get the data from the grid into a new recordset
Declare your recordset Private at the Form level.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com