Query Child Nodes Tree View (1 Viewer)

[Donovansmth]

Hello, is it possible to query the child nodes that show based on the id field in a text box?

An AfterUpdate to the id field, the child nodes update and refresh to show child nodes that share the same parent ID.

scenerio - year(ID), Class(Parent), student(child)

On the home page if the year changes,m(text box), then the students nodes should change to match the year, the classes won’t change. When I click the student node, I have a form that updates and shows the student data .

All features work, however because the tree view is activex, I’m not sure of the process to make this query work.

Thanks for any direction

 

[Ranman256]

My advice it so stop using tree view. It must be programmed.

instead,
use the SWITCHBOARD, you only need add values.
or
a continuous form with a text box/combo box for users to filter results.

sub txtBoxFilter_afterupdate()

if  isnull(txtBoxFilter) then 
   me.filterOn = false
else
  me.filter = "[field]='"  &   txtBoxFilter & "'"
   me.filterOn = true
end sub

 

[Pat Hartman]

I just posted this recently. It might give you a different idea for an interface that can be controlled with minimal code.

Master/Child links for Main form with three subforms

This application shows how to use master/child links as well as criteria in subform RecordSource queries to sync three subforms to a bound main form. Members is the top level subform and dependents is the lowest level subform. The third subform is used to show that you can also drill down more...

www.access-programmers.co.uk