B
Buckwheat
We have a form with a textbox which is populated by the following query:
SELECT tblSrc.TC_Area_Number, Space([NbrSpacesIndent]) & [Area_Name] AS
Area_Name_Indented, (Len([TC_Area_Number])-2)*2 AS NbrSpacesIndent FROM
TC_Area AS tblSrc ORDER BY tblSrc.TC_Area_Number;
The result is a seemingly hierarchical list of items representing different
test areas. However, the list is static, and as it gets longer, navigation
through the list is tedious. I know very little about VB and I have looked
at the links posted in this NG regarding the TreeView control. But I am
still not sure how I would convert this query result in list form to a tree.
Please help.
SELECT tblSrc.TC_Area_Number, Space([NbrSpacesIndent]) & [Area_Name] AS
Area_Name_Indented, (Len([TC_Area_Number])-2)*2 AS NbrSpacesIndent FROM
TC_Area AS tblSrc ORDER BY tblSrc.TC_Area_Number;
The result is a seemingly hierarchical list of items representing different
test areas. However, the list is static, and as it gets longer, navigation
through the list is tedious. I know very little about VB and I have looked
at the links posted in this NG regarding the TreeView control. But I am
still not sure how I would convert this query result in list form to a tree.
Please help.