主题：求助如何改成后台查询

如下是一段TextBox1文本数值改变后执行的时间，现在我把成交录入设置成了分页加载，再用一下代码就不能实现后台的加载了，请问我应该如何改这个代码，谢谢

Dim txt As String = e.Form.Controls("TextBox1").Text
Dim tbl As Table = Tables("成交录入")
If txt = "" Then
    tbl.Filter = ""
Else
    txt = "'%" & txt & "%'"
    tbl.Filter = "合同编号 Like " & txt & " Or 客源编号 Like " & txt & " Or 房屋编号 Like " & txt & " Or 甲方姓名 Like " & txt & " Or 甲方电话 Like " & txt & " Or 甲方身份证号码 Like " & txt & " Or 乙方身份证号码 Like " & txt & " Or 乙方姓名 Like " & txt & " Or 物业地址 Like " & txt & " Or 成交门店 Like " & txt & " Or 乙方电话 Like " & txt & " Or 成交类型 Like " & txt & " Or 所属区域 Like " & txt
End If