Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    7

    Unanswered: How to access child recordset of a hierarchical cursor in code?

    I am not able to access the child Recordset in the following code:

    mrstDayBook.Fields("Chapter1").Fields(bbbdbName).V alue

    where mrstDaybook is a hierarchical recordset produced by a SHAPE command and "Chapter1" is the ( default ) name of the field automatically appended to a parent Recordset by the SHAPE command.

  2. #2
    Join Date
    Mar 2004
    Posts
    6
    The chapter (subordinate recordset) can only be accessed as a recordset.

    Dim workingRecordset as recordset
    workingrecordset = mrstDayBook.Fields("Chapter1").Value

    while not workingrecordset.eof
    ' do your stuff
    workingrecordset.movenext
    wend

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •