Dim Value()As String Value = e.Node.FullPath.Split("\") Select Case e.Node.Level Case 0 If e.Node.Index = 0 Then Tables("全国物流园").Filter = "" Else Tables("全国物流园").Filter ="[省份] = '" & Value(0) & "'" End If Case 1 Tables("全国物流园").Filter ="[省份] = '" & Value(0) & "' And [市级] = '" & Value(1) & "'" End Select