Create Explorer (File Manager) Style Drill Down

[Frenstall]

Hello, I am wondering if there is an efficient way to create an explorer style drill down for a location/equipment table I have

i.e.

-Dept
+Finance
+HR
-Quality
+Supplier
+QA
-General
+Etc1
-Etc2
+Production

I have used the tree control to acomplish this but the major drawback I have found is it becomes WAY too slow when utilizing large amounts of data due to many embeded loops. Does anyone know an alternative or a way to program the tree control to only add nodes once a selection is expanded?

Basically I want this to operate as a drilldown of infinate levels with the speed of windows explorer. Unfortunatly all the code I have seen requires that all nodes are designated/Created when the form is loaded.

Any thoughts are greatly appreciated

 

[Adeptus]

I haven't done much with tree view, so this is just an idea...
Does it have an "expand" event? ie, can you tie code to the click to expand a category?

If so, put a single placeholder subcategory, with text "Please wait" or something, so the "+" appears.
Then have the "expand" code deleting the placeholder & adding all the real items.

 

[MarkK]

I've posted a sample db here http://www.access-programmers.co.uk/forums/showthread.php?t=102667
that progressively populates tree nodes when a node is expanded. Might offer a starting place.

 

[Frenstall]

Hey lagbolt, this looks like what I'm looking for, just couldn't seem to find it when I searched... thanks for the help!