Filters to Drill into a Hierarchy

  • Thread starter Thread starter Ross
  • Start date Start date
R

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
 
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".
 
Back
Top