Dim Filter As String
With e.Form.Controls("ComboBox2")
If .Value IsNot Nothing Then
Filter = "标识 = '" & .Value & "'"
End If
End With
With e.Form.Controls("ComboBox1")
If .Value IsNot Nothing Then
If Filter > "" Then
Filter = Filter & " And "
End If
Filter = Filter & "姓名 = '" & .Value & "'"
End If
End With
If e.Form.Controls("CheckBox2").Checked ' 如果付款状态选择了"已付"
If Filter >"" Then
Filter = Filter & " And "
End If
Filter = Filter & "已申请 = 1"
End If
If e.Form.Controls("CheckBox3").Checked ' 如果付款状态选择了"未付"
If Filter >"" Then
Filter = Filter & " And "
End If
Filter = Filter & "已申请 = 0 Or 已申请 Is Null"
End If
DataTables("实验室检查").LoadFilter = filter
DataTables("实验室检查").Load
加好友 
发短信
Post By：2014/8/19 17:18:00 [显示全部帖子]
