- Foxtable(狐表) (http://foxtable.net/bbs/index.asp)
-- 专家坐堂 (http://foxtable.net/bbs/list.asp?boardid=2)
---- 选择正确查询值 无法正常显示筛选 (http://foxtable.net/bbs/dispbbs.asp?boardid=2&id=121353)
-- 发布时间：2018/7/4 14:44:00
-- 选择正确查询值 无法正常显示筛选
RT
本人新人，第一次发帖。
烦请大佬帮看下哪里能错了，在线等。
···················································
下面是查询功能的代码
···················································
Dim pp As WinForm.ComboBox = e.Form.Controls("品牌")
Dim zl As WinForm.ComboBox = e.Form.Controls("种类")
Dim nd As WinForm.TextBox = e.Form.Controls("年度")
Dim ys As WinForm.TextBox = e.Form.Controls("颜色")
Dim bh As WinForm.TextBox = e.Form.Controls("编号")
Dim cm As WinForm.TextBox = e.Form.Controls("尺码")
Tables("商品信息表").Filter = "品牌 like \'*" & pp.Text & "*\' And 种类 like \'*" & zl.Text & "*\' and 年度 like \'*" & nd.Text & "*\' and 颜色 like \'*" & ys.Text & "*\' And 编号 Like \'*" & bh.Text & "*\' and 尺码 like \'*" & cm.Text & "*\' "
·····································································
附件1图 选择正确查询值 显示筛选结果
此主题相关图片如下：1.png
附件2图 选择正确查询值 不显示筛选结果
此主题相关图片如下：2.png
附件3图 选择正确查询值 不显示筛选结果
此主题相关图片如下：3.png
······································································
源文件见附件lz.rar
| 下载信息 [文件大小： 下载次数： ] | |
 点击浏览该文件:lz.rar |
·······································································
[此贴子已经被作者于2018/7/4 14:46:31编辑过]
-- 发布时间：2018/7/4 14:59:00
--
在线等
-- 发布时间：2018/7/4 15:56:00
--
你这样写筛选代码不正确。参考
http://www.foxtable.com/webhelp/scr/1058.htm
-- 发布时间：2018/7/4 16:11:00
--
谢谢！我看下~新人
-- 发布时间：2018/7/4 16:27:00
--