Private Function FindNode(NodeX As Node)
Dim N As Long
Dim StrSql As String
Dim MoNode() As Node
Dim AddId As Long
Dim TmpNode As Node
If NodeX.Children > 0 Then
AddId = 0
N = NodeX.Child.Index
If TrvName.Nodes(N).Children > 0 Then
AddId = AddId + 1
ReDim Preserve MoNode(AddId)
Set MoNode(AddId - 1) = TrvName.Nodes(N)
Else
Set TmpNode = TrvName.Nodes(N)
End If
While N <> NodeX.Child.LastSibling.Index
N = TrvName.Nodes(N).Next.Index
If TrvName.Nodes(N).Children > 0 Then
AddId = AddId + 1
ReDim Preserve MoNode(AddId)
Set MoNode(AddId - 1) = TrvName.Nodes(N)
Else
Set TmpNode = TrvName.Nodes(N)
End If
Wend
If AddId > 0 Then
For N = 0 To AddId - 1
Call FindNode(MoNode(N))
Next
End If
End If