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

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

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

也不行呀！

我上传了言文件 在订单标准表窗口的目录树 按了子节点就提示错误！！！！！！！

下载信息  [文件大小：   下载次数： ]

点击浏览该文件:订单管理_0714.zip

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
Dim ndf As WinForm.TreeNode = trv.SelectedNode
If ndf IsNot Nothing Then   
    If ndf.Checked Then
        If ndf.Level = 0 Then '注意下面的条件都要用括号括起来
            a = ndf.Text
            flt = " 审核 = '" & a & "'"
        End If
        If ndf.Level = 1 Then
            a = ndf.ParentNode.text
            b = ndf.Text
            flt = "审核 = '" & a & "' And 客户 = '" & b & "'"
        End If        
        If ndf.Level = 2 Then
            Dim pth() As String = ndf.FullPath.Split("\")
            a = pth(0)
            b = pth(1)
            c = ndf.Text
            flt = "审核 = '" & a & "' And 客户 = '" & b & "' And 款号= '" & c & "'"
        End If
    End If
End If 

    Tables("订单标准").Filter = flt

楼上狐神厉害,再分享一下狐爸曾经帮助过我的代码:

Dim trv As WinForm.TreeView = e.Sender
Dim flt 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.Level > 0 AndAlso nd.ParentNode.Checked Then '如果父节点选中
        Continue For '跳过此节点,处理下一结点
    End If
    If nd.Checked Then
        If flt > "" Then
            flt = flt & " Or "  '注意用or而不是And
        End If
        If nd.Level = 0 Then '注意下面的条件都要用括号括起来
            flt = flt & "(审核 = " & nd.Text & ")"
        ElseIf nd.Level = 1 Then '注意下面的条件都要用括号括起来
            flt = flt & "(审核 = " & nd.ParentNode.Text & " And 客户 = '" & nd.text & "')"
        Else
            flt = flt & "(审核 = " & nd.ParentNode.ParentNode.Text & " And 客户 = '" & nd.ParentNode.text & "' And 款号 = '" & nd.Text  & "')"
        End If
    End If
Next
Tables("订单标准").Filter = flt

追加一个问题:

"审核"是逻辑型,在节点显示"True"或"False" ,能改变显示成"审核"和"未审"吗?

Dim trv As WinForm.TreeView = e.Form.Controls("TreeView1")
For Each nd As WinForm.TreeNode In trv.AllNodes
  If nd.Text = "True" Then

      nd.Text = "审核"

   Elseif nd.Text= "False"

      nd.Text = "未审"
   End If
Next

参考：

http://www.foxtable.com/help/topics/2302.htm

借楼主的地请教狐爹！！！

下载信息  [文件大小：   下载次数： ]

点击浏览该文件:文件管家.foxdb

如何用多选目录树的复选框对表进行筛选？？

比如当我点选编程下的开发项目，再点选软件下 手机软件的诺基亚复选框，会筛选出相应的行在表中

先谢谢楼主与狐爹

1、不同的问题，最好分别发帖提问，不要跟在人家后面。

2、看看这个例子：

http://www.foxtable.com/help/topics/2503.htm