主题：在设计“添加物料”时，[upload=table,杭兴五金管理系统.table]viewFile.asp?ID=73354[/upload] 代码照视频设计后，老是提示 like 运算符出错：字符串模式“*品名的内容*”无效。我查不到原因。请老师帮忙。

Dim cj As WinForm.ComboBox = e.Form.Controls("客户名称")
Dim khdj As WinForm.ComboBox = e.Form.Controls("客户等级")
Dim bmgg As WinForm.TextBox = e.Form.Controls("品名规格")
Dim jbbh As WinForm.TextBox = e.Form.Controls("产品编码")

Tables("物料信息表").filter="客户名称= '" & cj.text & "' and 客户等级 like '*" & khdj.text & "' and 品名规格 like '*" & bmgg.text & "*' and 产品编码 like '*" & jbbh.text.replace("*", "[*]") & "*'"

正规的查询参考

http://www.foxtable.com/help/topics/1058.htm

你就不能改改？

Dim cbbm As WinForm.TextBox = e.Form.Controls("产品编码")
Dim khmc As WinForm.TextBox = e.Form.Controls("客户名称")
Dim bmgg As WinForm.ComboBox = e.Form.Controls("品名规格")

Tables("添加物料_物料信息表").Filter = "产品编码 like '*" & cbbm.Text & "*' and 品名规格 like '*" & bmgg.Text.replace("*", "[*]") & "*' and 客户名称 like '*" & khmc.Text & "'and 客户名称 = '" & Tables("订单主表").Current("订单客户") & "'"