I wanted to use 2 for next loops to put the category in the expandable row and the record(s) underneath each category ,as a test I just wanted to use two loops to give me a hierarchical list, but I must be doing something wrong… I took the code from the listbox hierarchical list example, but this does not work. I do not know what I am doing wrong. It should be easy to add as many child (nodes?) as you need. imoho.
for i as integer = 0 to Categories.Count-1
me.AddExpandableRow(i.ToText + ". " + Categories(i).ToText)
dim z as integer
for z = 0 to Categories.Count-1
Me.AddExpandableRowAt( i,i.ToText + "— " + Categories(z).ToText,1)
next z
// // try loading categories and displaying records under the category
next i