PDA

View Full Version : Solved: Populating treeView



Kaizer
02-24-2006, 02:09 AM
Le me ask you on the treeView. I have a sheet with three columns that will have to be used for populating the treeView. Column A has only one value = "EMEA". This will be the First parent in the tree view. Column B has Regions that belong to EMEA. This should be second Parent in the treeView. Column C has countries that belong to the regions. This is the child for the treeView. My question is how to populate the treeView using the code? I attach the file with the Form and treeView on it and the Data sheet. Can you help?

Bob Phillips
02-24-2006, 02:44 AM
Here you are

Kaizer
02-24-2006, 03:03 AM
Thanks xld. That's what I need! :)

Kaizer
02-24-2006, 03:11 AM
XLD, I just noticed that not all the countries were populated. For example Italy region should include two countries. And it's not the case in the attached file.

Bob Phillips
02-24-2006, 03:47 AM
Logic error

Kaizer
02-24-2006, 03:49 AM
Great, thank you. :)

Bob Phillips
02-24-2006, 03:53 AM
One thing, you have two categories, Actual and Budget, and some countries are only in one category. The code I gave will pick up the value from actual, but any in Budget not in Actual will also be picked up. Is that what you want?

Kaizer
02-24-2006, 03:56 AM
Yes, I need the countries for all the categories.

Bob Phillips
02-24-2006, 07:09 AM
Yes, I need the countries for all the categories.

Pkay then, it should be alright as is.