Dim Filter As String
Dim txt As String = e.Form.Controls("TextBox1").Text
Dim dr As DataRow = e.Node.DataRow '获取生成此节点的行
If e.Node.Text <> "显示所有行" Then
Select Case e.Node.Level
Case 0
Filter = "[类别] = '" & dr("类别") & "'"
Case 1
Filter = "[类别] = '" & dr("类别") & "' And [项别] = '" & dr("项别") & "'"
End Select
End If
txt = "'%" & txt & "%'"
Dim Filter2 As String
Filter2 = "危险 Like " & txt & " or 预防 Like " & txt & " or 应急 Like " & txt
Tables("BasicLabel").Filter = Filter2 & "And" & Filter
Filter2 再增加相应格式的条件表达式，就不筛选了。
加好友 
发短信
Post By：2015/1/12 8:50:00 [显示全部帖子]
