Data Environment

[Rob HErmans]

I have set up a connection to an MDB
I have a Parent Command "Parents"
I have added a child command "Children"
It works beautifully.....the "linked" data moves beautifully
I wish to add records to the parents and the children
I have access to all of the ADO methods on rsParents (addnew,update,bookmark etc)
I cannot get accesss to the same methods for the child rsChildren
Note:I have set up returning recordset on
advanced tab

I have also tried following with no success
dim rsKids as adodb.recordset
set rskids = rsparents.field?("CHILDREN")

Still no luck
This is a great forum
I hope I can contribute also
Thanks
Rob Hermans
Philadelphia

[Rob Hermans]

I have set up a connection to an MDB
I have a Parent Command "Parents"
I have added a child command "Children"
It works beautifully.....the "linked" data moves beautifully
I wish to add records to the parents and the children
I have access to all of the ADO methods on rsParents (addnew,update,bookmark etc)
I cannot get accesss to the same methods for the child rsChildren
Note:I have set up returning recordset on
advanced tab

I have also tried following with no success
dim rsKids as adodb.recordset
set rskids = rsparents.field?("CHILDREN")

Still no luck
This is a great forum
I hope I can contribute also
Thanks
Rob Hermans
Philadelphia

Hi Rob,

You can get access to the next recordset by calling the "NextRecordset" method which is part of the the ADODB.Recordset object.

E.g.
Dim rsKids As ADODB.RecordSet
Set rsKids = rsParents.NextRecordset

Hope this helps.

Vick Soulios

[Rob HErmans]

I have TWO related recordsets - is there a way to distinguish between WHICH next I want??
Thanks for your help!!!

[Rob Hermans]

I have TWO related recordsets - is there a way to distinguish between WHICH next I want??
Thanks for your help!!!