Janus Gridex - Updating Disconnected Recordset

[RitchieBoy]

I have a janus Gridex on a form, and am populating it using a recordset for which i have set the Active connection to nothing (as i dont wont to update to the same place as i am retrieving the data).

The problem i am having is that i want the users to be able to update some of the fields in the gridex, and i need to capture these changes.

Ideally i would like to update the recordset that i populated the gridex with, with the updated information (so i can then use it to save back to a table).

Code ****

Option Explicit
'form variables
dim strPath As String
Dim strReturnDocs As String
Dim rs As New ADODB.Recordset

Private Sub Form_Load()

With DEGlobalPrinting ' Data Environment
.dbo_bq_GetDIRFiles strPath, strReturnDocs 'Stored Proc
rs.LockType = adLockOptimistic
Set rs = .rsdbo_bq_GetDIRFiles.Clone
Set rs.ActiveConnection = Nothing
Set Me.gexResults.ADORecordset = rs
gexResults.SelectionStyle = jgexEntireRow
gexResults.HideSelection = jgexHighLightNormal

'gexResults - is the name of the gridex

end with

End Sub

********************

This code works fine, but i can't get the gridex to update the rs = to the updated version of the record which is shown in the gridex after the user has made a change.

Any help - at all would be v.v.v.v Appreciated - or just to say this is impossible, any feedback will be gratefully recieved (as i have been working on this all day, and it's been like banging my head against a wall)

cHEERS
Richard