Dim Filter As String
With e.Form.Controls("Addno")
If .Value IsNot Nothing Then
If Filter >"" Then
Filter = Filter & " And "
End If
Filter = Filter & "convert(添加编号, varchar) like '%" & .Value & "%'"
End If
End With
With e.Form.Controls("Recordman")
If .Value IsNot Nothing Then
If Filter >"" Then
Filter = Filter & " And "
End If
Filter = Filter & "convert(记录人, varchar) like '%" & .Value & "%'"
End If
End With
If Filter > "" Then
DataTables("B_TtemNo").LoadFilter = Filter
DataTables("B_TtemNo").Load()
End If