Subquery in a Subform

[P_Henry]

Hi,

I am trying modify my forms so that I can display data like a tree view. I have a mainform and a subform. The source of the subform is a datasheet view of a query which has children linked to it. I have attached a snapshot view to this post.
How do I access a field in the child in the subform (it is not a subsub form - it is a subquery within a subform)? (Field need to be accessed highlighted in black in th snapshot)

Thanks
PH

 

[P_Henry]

Hi,
Is this probably a wrong way to do the tree ctrl view - please give suggestions.
Thanks,
Priya