Filters to Drill into a Hierarchy

[Ross]

I want to design a form that drills into records in a similar fashion and
look that is part of the Excel "Filter" function.

I have Departments--> Sub-Departments--> Categories--> Sub-Categories and
UPCs at the lowest level.

What technology would be required to have a form window showing ie
List of available dept with a + = Selected, and - = Unselected (Select All
Option). This would expand to available Sub-Depts with + = Selected, and - =
Unselected. Would this have to be done with a VB form, C++, Windows
operating system technology, or what.

I am assuming that this can't be done with a standard Access from.

thank you

Ross

 

[Dorian]

You can do this via the Tree View control.
You will have to priogram it all yourself in VB and it is pretty advanced
stuff.
However, it does work and is pretty neat. I've used it myself.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[Ross]

Dorian,

I think that I am able to fish now. Thank you.

Ross