With e.Form
If e.sender.text <> "模糊条件" Then
Dim dst As Table = Tables("准驾信息")
Dim txb1 As WinForm.TextBox = .Controls("模糊条件")
dst.Filter = "[车牌号] Like '*" & txb1.text & "*' or [驾驶员] Like '*" & txb1.text & "*'or [所属部门] Like '*" & txb1.text & "*'or [使用状态] Like '*" & txb1.text & "*'or [车辆型号] Like '*" & txb1.text & "*'"
End If
End With
上面代码以前再normal表中使用正常,可以对驾驶员进行搜索,把副本表改成sql表后,提示无法找到驾驶员,字段驾驶员为表达式,是不是因为表达式不在后台存储的数据源中?有没有办法可以表达式“驾驶员"进行搜索?