你写代码不是一般的不严谨:
Select Case e.Node.Level
Case 0
Filter ="[咨询作业_作业日期] = '" & Value(0) & "'"
Case 1
Filter ="[咨询作业_作业日期] = '" & Value(0) & "' And [咨询项目_一级名称] = '" & Value(1) & "'"
Case 1
Filter ="[咨询作业_作业日期] = '" & Value(0) & "' And [咨询项目_一级名称] = '" & Value(1) & "' And [咨询项目_委托人] = '" & Value(1) & "'"
End Select
怎么会有两个Case 1 ,第三段怎么有两个Value(1)
应该:
Select Case e.Node.Level
Case 0
Filter ="[咨询作业_作业日期] = '" & Value(0) & "'"
Case 1
Filter ="[咨询作业_作业日期] = '" & Value(0) & "' And [咨询项目_一级名称] = '" & Value(1) & "'"
Case 2
Filter ="[咨询作业_作业日期] = '" & Value(0) & "' And [咨询项目_一级名称] = '" & Value(1) & "' And [咨询项目_委托人] = '" & Value(2) & "'"
End Select