主题：Label26作为查询

Dim Filter As String

With e.Form.Controls("TextBox7")

    If .Value IsNot Nothing Then

        If Filter > "" Then

            Filter = Filter & " And "

        End If

        Filter = Filter & "连接编号 = '" & .Value & "'"   '此处内容自行修改

    End If

End With

If Filter > "" Then

    Tables("企业档案窗口_Table4").Filter = Filter

End If

为什么TextBox7必须要可见才能有效呢？