關(guān)于窗體上建立篩選的方式, Henry D. Sy老師教了一種方式(http://ctxi.cn/thread-113136-1-2.html),但是我轉(zhuǎn)移到自己的里面,發(fā)現(xiàn)其他三個都好用,其中的部門這個篩選不好用,請大家?guī)兔纯词鞘裁丛颍恐x謝
Option Compare Database
Option Explicit
Function gString()
Dim ctl As Control
For Each ctl In Me.Controls
If TypeOf ctl Is ComboBox Then
If Not IsNull(ctl) Then
gString = gString & ctl.Name & "='" & ctl & "' And "
End If
End If
Next
If Len(gString) <> 0 Then
gString = Left(gString, Len(gString) - 5)
Me.花名冊_整體子窗體1.Form.Filter = gString
Me.花名冊_整體子窗體1.Form.FilterOn = True
Me.花名冊_整體子窗體2.Form.Filter = gString
Me.花名冊_整體子窗體2.Form.FilterOn = True
End If
End Function
Private Sub Command12_Click()
Dim ctl As Control
For Each ctl In Me.Controls
If TypeOf ctl Is ComboBox Then
ctl = Null
End If
Next
Me.花名冊_整體子窗體1.Form.FilterOn = False
Me.花名冊_整體子窗體2.Form.FilterOn = False
End Sub