Foxtable(狐表)用户栏目专家坐堂 → 模糊筛选


  共有3427人关注过本帖平板打印复制链接

主题:模糊筛选

帅哥哟,离线,有人找我吗?
asionwong
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:幼狐 帖子:170 积分:1563 威望:0 精华:0 注册:2013/8/21 9:41:00
模糊筛选  发帖心情 Post By:2022/1/14 12:34:00 [只看该作者]

Dim Filter As String
With
e.Form.Controls("cmbProduct")
   
If .Value IsNot Nothing Then
        Filter =
"产品 = '" & .Value & "'"
   
End If
End
With
With
e.Form.Controls("cmbCustomer")
   
If .Value IsNot Nothing Then
       
If Filter > "" Then
            Filter = Filter &
" And "
       
End If
        Filter = Filter &
"客户 = '" & .Value & "'"
   
End If
End
With
If
Filter > "" Then
    Tables(
"订单").Filter = Filter
End If

如果需要改为模糊筛选,"="改为Like吗?请问怎么改?谢谢


 回到顶部