OK, I still haven't gotten this figured out yet so I am asking it again. Please bare with me because I am very confused. Also note that I am not just asking how to do what I am trying to do, but also is there a better/easier way.
Scenerio
frmOrder - Contains header (bound to txt fields) and detail (datagrid)
clsOrder - Class module that controls my recordset.
Contains Primary (header) and Secondary
(Detail) Datamembers
frmDetail - Form I wish selected record to appear in.
My problem is this
frmOrder comes up with the correct information. All I want to do is double click on a record in my datagrid and have the frmDetail come up with that specific record.
I could pass the details record ID field Globally to the form, but I wanted to see if I could access that detail record that was double clicked in frmOrder, but have NO idea how to do that.
Comments, Suggestions?
Scenerio
frmOrder - Contains header (bound to txt fields) and detail (datagrid)
clsOrder - Class module that controls my recordset.
Contains Primary (header) and Secondary
(Detail) Datamembers
frmDetail - Form I wish selected record to appear in.
My problem is this
frmOrder comes up with the correct information. All I want to do is double click on a record in my datagrid and have the frmDetail come up with that specific record.
I could pass the details record ID field Globally to the form, but I wanted to see if I could access that detail record that was double clicked in frmOrder, but have NO idea how to do that.
Comments, Suggestions?