主题：[求助] 复选框目录树 增加节点

^_^，我都以为您是要给大家分享问题，都没有看！

仔仔细细看完这个帖子，您就知道为啥，您的问题也就迎刃而解了！

Dim trv As WinForm.TreeView = e.Sender
Dim flt,a,b,c As String
For Each nd As WinForm.TreeNode In e.node.Nodes '同步子节点选中状态
    nd.Checked = e.Node.Checked
Next
If e.node.ParentNode IsNot Nothing Then '去掉父节点选中状态
    e.node.ParentNode.Checked = False
End If
If nd.Level > 0 AndAlso nd.ParentNode.Checked Then '如果父节点选中
    For Each nd As WinForm.TreeNode In trv.AllNodes
        If nd.Checked Then
            If nd.Level = 0 Then '注意下面的条件都要用括号括起来
                a = nd.Text
                flt = " 审核 = '" & a & "'"
            End If
            If nd.Level = 1 Then
                b = nd.Text
                flt = "审核 = '" & a & "' And 客户 = '" & b & "'"
            End If
            If nd.Level = 2 Then
                c = nd.Text
                flt = "审核 = '" & a & "' And 客户 = '" & b & "' And 款号= '" & c & "'"
            End If
        End If
    Next
End If
Tables("订单标准").Filter = flt

无文件，没法测试，去掉判断看看什么现象：

 

Dim trv As WinForm.TreeView = e.Sender
Dim flt,a,b,c As String
For Each nd As WinForm.TreeNode In e.node.Nodes '同步子节点选中状态
    nd.Checked = e.Node.Checked
Next
If e.node.ParentNode IsNot Nothing Then '去掉父节点选中状态
    e.node.ParentNode.Checked = False
End If
For Each nd As WinForm.TreeNode In trv.AllNodes
    If nd.Checked Then
        If nd.Level = 0 Then '注意下面的条件都要用括号括起来
            a = nd.Text
            flt = " 审核 = '" & a & "'"
        End If
        If nd.Level = 1 Then
            b = nd.Text
            flt = "审核 = '" & a & "' And 客户 = '" & b & "'"
        End If
        If nd.Level = 2 Then
            c = nd.Text
            flt = "审核 = '" & a & "' And 客户 = '" & b & "' And 款号= '" & c & "'"
        End If
    End If
Next
Tables("订单标准").Filter = flt

呵呵，刚刚没去掉就给您了原来复制的：

 

Dim trv As WinForm.TreeView = e.Sender
Dim flt,a,b,c As String
For Each nd As WinForm.TreeNode In e.node.Nodes '同步子节点选中状态
    nd.Checked = e.Node.Checked
Next
If e.node.ParentNode IsNot Nothing Then '去掉父节点选中状态
    e.node.ParentNode.Checked = False
End If
For Each nd As WinForm.TreeNode In trv.AllNodes
    If nd.Checked Then
        If nd.Level = 0 Then '注意下面的条件都要用括号括起来
            a = nd.Text
            flt = " 审核 = '" & a & "'"
        End If
        If nd.Level = 1 Then
            b = nd.Text
            flt = "审核 = '" & a & "' And 客户 = '" & b & "'"
        End If
        If nd.Level = 2 Then
            c = nd.Text
            flt = "审核 = '" & a & "' And 客户 = '" & b & "' And 款号= '" & c & "'"
        End If
    End If
Next
Tables("订单标准").Filter = flt