Hi,
I hope I phrased this post correctly, possibly not!
Currently I have a dBGrid object which is data bound to a DAO recordset on the same form. The recordset datMembers' is linked to 'tblMembers' in the back end MSAccess98 database using a 'Dynaset' type recordset. All works fine!
However, I have tried unsuccessfully to make my solution more elegant placing a dBGrid on a second form specifically to view user details in a 'broadsheet' format thus de-cluttering the calling form. The DBGrid on the second form therefore needs to be 'data-bound' to the DAO on the calling form.
So I suppose I am looking for data-bindings across form objects. Can this be done?. I have tried unsuccessfully using several approaches - using the grids datasource property and attempting to link the DBGrid from the calling form. I cant find anything in my Wrox VB6 Programming book (My Bible!) or other published sources which help on this issue; they all focus on data linking DAO/ADO recordsets to display objects - on the same form!
This type of functionality is common with many applications when related sub-windows are brought up modally, but the technique eludes me at present.
Thanks in anticipation of advice
I hope I phrased this post correctly, possibly not!
Currently I have a dBGrid object which is data bound to a DAO recordset on the same form. The recordset datMembers' is linked to 'tblMembers' in the back end MSAccess98 database using a 'Dynaset' type recordset. All works fine!
However, I have tried unsuccessfully to make my solution more elegant placing a dBGrid on a second form specifically to view user details in a 'broadsheet' format thus de-cluttering the calling form. The DBGrid on the second form therefore needs to be 'data-bound' to the DAO on the calling form.
So I suppose I am looking for data-bindings across form objects. Can this be done?. I have tried unsuccessfully using several approaches - using the grids datasource property and attempting to link the DBGrid from the calling form. I cant find anything in my Wrox VB6 Programming book (My Bible!) or other published sources which help on this issue; they all focus on data linking DAO/ADO recordsets to display objects - on the same form!
This type of functionality is common with many applications when related sub-windows are brought up modally, but the technique eludes me at present.
Thanks in anticipation of advice