combo box window / tree view?

[Guest]

Is there some way to permanently display a window on a form that contains all
the choices of a combo box in lieu of a drop down list? If so, is there is a
way to display to display something in tree view and have the ability to
collapse, as an example, products under a product category? I'm looking at
cascading combo boxes, but am just wondering if this is even a possibility.

Thanks in advance for any suggestions!

 

[Rob Parker]

You could use a tree-view control (available in the "More controls" section
of the toolbox) on your form to give this capability. However, if you do
decide to do this, you will need to be reasonably competent with VBA, since
the control cannot be bound directly to data (as with a combo-box, for
example); you will need to write code to populate the control, manipulate
related information on your form, etc.

If you want some more info, here's a few links that should help:
http://msdn.microsoft.com/library/d...conscenarioviewingbibliomdbdatabaseastree.asp

http://msdn.microsoft.com/library/d...us/vbcon98/html/vbconusingtreeviewcontrol.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsmart00/html/sa00j14.asp
(watch for line-splitting on the above three links)

and
http://www.helenfeddema.com/access.htm, in particular accarch53 and
accarch103.

And, saving the best 'til last, the most comprehensive sample I've seen is
available at
http://www.pointltd.com/Downloads/Details.asp?dlID=36
Well worth downloading.

HTH,

Rob