I am creating a database software application using Microsoft Access 2000 and would like to construct a list box (SelectionList) on a form (MyForm) to display expansion +/- boxes like on-line Help says a Pivot Table will display. (much like the Explorer Window displays a computers directory and file hierarchy)
My list box is based on a 4 level query that is normalized and produces the correct record set. How do I permanently add this functionality (tool) into my Access development environment? Is it an ActiveX Control ? or what? Help explains I should click on the Toolbar ?Property Toolbox? and select the ?Show / Hide? bar ?Expansion Indicators?.
Where can I find (and/or download) these elusive little devils? Enter ?Hierarchy List? into the ?What would you like to do?? Access Help window and click Search to see what I get. I do not want to involve Excel (exports an imports ? or links) unless absolutely necessary.
Thanks for your Help ? Don Quigg