老师,这段代码在下拉窗口的DROPDOWNOPENED事件中,提示运算符后缺少操作数,请您指导。序号是数字,我已经设置成字符。
Dim txt As String = e.Form.DropDownBox.Text
Dim tbl As Table = Tables("合同信息下拉窗口录fa piao_Table1")
If txt = "" Then
tbl.Filter = ""
Else
txt = "'%" & txt & "%'"
tbl.Filter = "Convert(序号, 'System.String') " & txt
End If
e.Form.DropDownBox.Select() '将输入焦点返回下拉列表框