asked on

Access 2007 VBA expand treeview from the selected node

Hello all,
I've been searching everywhere for this and can't seem to find the answer. It seems to me that it would be a fairly common question for people using a treeview control, but I can't find anything...

I have a treeview control on an Access 2007 form where I would like the user to be able to select a node in the treeview and then click a command button which will expand every node off of that selected parent.

Any help would greatly be appreciated.
Thanks...

Dale Fye

I have not used a treeview in a while, but the best resource I've found for treeviews is:

http://mytreeviewblog.blogspot.com/

The guy who wrote this put together a 6 or 7 part series that covers just about anything you could want to know about a treeview control.

Episode #4 covers expanding and collapsing nodes.

http://mymsaccessblog.blogspot.com/2008/03/my-treeview-project-episode-4-expand.html

shannonds

ASKER

Thanks Dale... I actually already knew about that blog and have already read the entire series. I already know how to expand (all) and collapse (all). My problem is, how to do it from a selected node.

Thanks for trying...

ASKER CERTIFIED SOLUTION

shannonds

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

shannonds

ASKER

Works like a charm... Granted I pulled all my hair out trying to figure it out.