Class Objects, ADO, Header/Detail Datagrid, Selection Help!!!!!

[Cranger]

Maybe I am biting off more than I can chew. This started from an earlier thread, but I do not think I asked the question well so I am trying again. Also remember I am not an expert!

What I have

Class Object that uses PROVIDER=MSDataShape;Data PROVIDER=MSDASQL ado connection that looks at a header (order) and Child (detail).

This is used by a form that lists the header information displayed in text fields and detail information displayed in the datagrid.

I want to select a detail record (dbl click) and open a new form that shows the Whole detail record in text boxes for editing. I thought I could use the same adoRs that is already opened from the first form.

I do not understand how to bring up the form and point specifically to the item that I double clicked on in the datagrid.

Please someone help. If they can point me to an example somewhere I would appreciate it.

 

[CCLINT]

Set the recordset object in form2 to a clone of the recordset in form1:

Set Form2.MyRecordset = Form1.MyRecordset.Clone
Now set the current record in Form2 to the current record in Form1:

Form2.MyRecordset.Bookmark = Form1.MyRecordset.Bookmark

or, use the MyRecordset.Find method