Data Tree....

[Lee Taylor-Vaughan]

Hello group,

I dont know if i am using the correct work, but i want to put a collapsable
tree on my form.

The form will list organizations
under the organization there will be a discapline
in each discapine there will be a list of courses
under each course there will be required components for each course.

i want to be able to click say a '+' and each level of data is expandable.

where do i start to do this.. I looked through the list of active controls,
and there are so many, and i dont know which one to choose, so i figured i
would ask you for help...

Thank you

Lee

 

[Paul]

You want the Microsot TreeView control included in MSCOMCTL.OCX.

This can't be databound, i.e. you will have to use VBA to open the recordset
(with the organisations, disciplines and courses) and populate the 'nodes'
of the tree with this data.

I did an app some time ago that had a structure of Division, Department, Job
in one treeview and Area, Category, Skill in another. The TreeView worked
really well for this, but be warned, there is quite a bit of coding
involved.

The other thing to watch out for is that any client machine you want to run
your app on will need MSCOMCTL.OCX. While this is freely redistributable you
complicate the roll out of your application by having to check that it is
installed and installing/registering it if not.

If I get the chance I will post some sample TreeView code to my website
(www.pdtech.co.uk) but the last time I used the TreeView was in an early
project before I 'saw the light' of re-usable code and it might take me a
while to make the code generic enough to be useful to others.