Dim Value() As String Value = e.Node.FullPath.Split("\") Select Case e.Node.Level Case 0 If e.Node.Text = "显示所有行" Then Tables("订单主表").Filter = "未付金额 > 0" Else Tables("订单主表").Filter = "[客户编号] = '" & Value(0) & "' And 未付金额 > 0" End If Case 1 Tables("订单主表").Filter = "[客户编号] = '" & Value(0) & "' And [工作号] = '" & Value(1) & "' And 未付金额 > 0" End Select