主题：一个幼狐给单位写的程序。我的问题汇总，大神略过

Dim nms As String() = {"","",""} '指定生成目录树的各列

Dim nms1 As String() = {"","",""} '指定生成目录树的各列

Dim nms2 As String() = {"","",""} '指定生成目录树的各列

Dim qts As String() = {"'","'","'"} '指定将各列的值括起来的符号,这里都是字符型,所以都是单引号

Dim trv As WinForm.TreeView = e.Sender

Dim flt As String

Dim nd As WinForm.TreeNode

For Each nd In e.node.allNodes '清除子节点的选中标记

    nd.Checked = False

Next

nd = e.Node.ParentNode

Do While nd IsNot Nothing '清除父节点的选中标记

    nd.Checked = False

    nd = nd.ParentNode

Loop

For Each nd In trv.AllNodes

    If nd.Checked  Then

        If nd.FullPath Like "按设备*"

            nms1 = {"设备大类","设备二类","设备三类"}

        Else

            nms2 = {"单位","部门","责任人"}

        End If

        Dim rts() As String = nd.FullPath.Split("\")

        Dim val As String = ""

        Dim val1 As String = ""

        Dim val2 As String = ""

        

        For i As Integer = 1 To rts.Length - 1

            If val > "" Then

                val = val & " And "

            End If

            '            val = val & nms(i-1) & " = " & qts(i-1) & rts(i) & qts(i-1)

            val1 = val & nms1(i-1) & " = " & qts(i-1) & rts(i) & qts(i-1)

            val2 = val & nms2(i-1) & " = " & qts(i-1) & rts(i) & qts(i-1)

        Next

        

        If flt > "" Then

            '           flt = flt & " or (" & val & ")"

            flt = flt & " and (" & val1 & ")" &" And " & "(" & val2 & ")"

        Else

            flt = val

        End If

        MessageBox.Show(VAL)

        MessageBox.Show(VAL1)

        MessageBox.Show(VAL2)

        MessageBox.Show(FLT)

    End If

Next

Tables("主表").Filter  = flt