以下是引用飞天在2014-1-24 13:24:00的发言：
Dim Filter As String
With e.Form.Controls("控件1")
If .Value IsNot Nothing Then
Filter = "列名1 = '" & .Value & "'"
End If
End With
With e.Form.Controls("控件2")
If .Value IsNot Nothing Then
If Filter > "" Then
Filter = Filter & " And "
End If
Filter = Filter & "列名2 = '" & .Value & "'"
End If
End With
With e.Form.Controls("控件3")
If .Value IsNot Nothing Then
If Filter >"" Then
Filter = Filter & " And "
End If
Filter = Filter & "列名3 = '" & .Value & "'"
End If
End With
If Filter > "" Then
Tables("表A").Filter = Filter
End If
看不懂 只找到一个只带的 窗口筛选.table
加好友 
发短信
Post By：2014/1/24 13:01:00 [显示全部帖子]
Post By：2014/1/24 15:00:00 [显示全部帖子]
Post By：2014/1/24 15:22:00 [显示全部帖子]
此主题相关图片如下：qq浏览器截屏未命名.png
