我的筛选条件总共有5个,5个条件里面如入任何一个筛选都可以筛选,但是筛选显示的结果只有5个单元格里都有内容的才会在结果中显示,什么情况。我是用and连接表达式的,如果用Or直接就无法筛选。。哪里问题,下面是我的筛选表达式请参看。
Dim hyxm As WinForm.TextBox = e.Form.Controls("会员姓名")
Dim hykh As WinForm.TextBox = e.Form.Controls("会员卡号")
Dim hjgw As WinForm.ComboBox = e.Form.Controls("会籍顾问")
Dim hydh As WinForm.TextBox = e.Form.Controls("会员电话")
Dim hyjb As WinForm.ComboBox = e.Form.Controls("会员级别")
Tables("会员信息表").Filter = "会员姓名 like '*" & hyxm.Text & "*' and 会员卡号 like '*" & hykh.Text & "*' and 会籍顾问 like '*" & hjgw.Text & "*' and 手机号码 like '*" & hydh.Text & "*' and 会员级别 like '*" & hyjb.Text & "*'"
此主题相关图片如下:2.jpg
[此贴子已经被作者于2014-9-26 11:55:14编辑过]