以文本方式查看主题

-  Foxtable(狐表)  (http://foxtable.com/bbs/index.asp)
--  专家坐堂  (http://foxtable.com/bbs/list.asp?boardid=2)
----  多条件查询不符  (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=113326)

--  作者:有点蓝
--  发布时间:2018/1/13 14:48:00
--  
With e.Form.Controls("成品编码1")
    If .Value IsNot Nothing Then
        Filter = "成品编码 = \'" & .Value & "\'"
    End If
End With

改为

With e.Form.Controls("成品编码1")
    If .Value IsNot Nothing Then
        If Filter >"" Then
            Filter = Filter & " And "
        End If
        Filter = Filter & "成品编码= \'"   & .Value & "\'"
    End If
End With