主题：[求助][原创]错误提示，求解决办法

此主题相关图片如下：n6i623czl9dzzc524e4.jpg

 

一进去打开采购表就这个提示，什么意思，应该怎么解决

你的筛选表达式有问题，如果搞不定，将文件传上来，我帮你检查一下。

筛选代码

Dim Filter As String
With e.Form.Controls("Combdanhao")
    If .Value IsNot Nothing Then
        Filter = "采购单号 = '" & .Value & "'"
    End If
End With
With e.Form.Controls("Combgys")
    If .Value IsNot Nothing Then
        If Filter > "" Then
            Filter = Filter & " And "
        End If
        Filter = Filter & "供应商 = '" & .Value & "'"
    End If
End With
With e.Form.Controls("Combhuohao")
    If .Value IsNot Nothing Then
        If Filter >"" Then
            Filter = Filter & " And "
        End If
        Filter = Filter & "货号 = '" & .Value & "'"
    End If
End With
With e.Form.Controls("startdate")
    If .Value IsNot Nothing Then
        If Filter >"" Then
            Filter = Filter & " And "
        End If
        Filter = Filter & "日期 >= #" & .Value & "#"
    End If
End With
With e.Form.Controls("enddate")
    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

采购单号是逻辑列?

估计还是数据类型之类的出错了