Printable View
Hello Guys, How to navigate the records of child command??
I only know how to navigate the tables of Parent command but not for child.
DataEnvironment1.rscommand1.movenext
What bout child command?
I tried this but cannot work
DataEnvironment1.recordsets("rscommand2").movenext??
According to a White Paper provided by Microsoft, accessing child command objects requires that you create a Recordset obejct in code:
Dim|Public recordset1 as ADODB.Recordset
You must then assign the recordset object to the Parent-Command-object field that references the Child Command
Set recordset1 = DataEnvironment1.rscommand1.Fields("childcommand1").Value
Recordset1 now contains the records that correspond to the child command.
If you declare Recordset1 in the General section of the command DataEnvironment1 module and include "WithEvents" i.e.
Public WithEvents recordset1 as ADODB.Recordset
You have access to its events and can place code in the events.