What does "Access can't find the field "|" referred to in your expression..." mean???

Posted on 2005-05-06
Last Modified: 2008-01-09
I'm getting this error message whne i try to run a filter and I can't for the life of my figure out what it means.  There is no "|" referred to in any of my tables or expressions.  Any ideas?

Question by:MitchellVII
    LVL 39

    Expert Comment

    Sounds like the field name you are using in your Filter property is not part of the form.

    LVL 38

    Expert Comment

    Stevbe is correct...most of the time it is due to a mispelled name reference or incorrect case used when referring to a control or field.
    LVL 5

    Author Comment

    Ok, I found the problem.  Weird Access-related thing I think.  I was creating a Query Object using some complex code.  That query was then being used as a filter for my form and i was getting this error message, but only on forms where the underlying tables were over 10,000 records.  I think Access was getting bogged down on the timing of when it was performing things.

    Anyway, instead of creating the query and using that as the basis for the filter, I just created a table and appended the records generated by my query to that.  I then used the table as the basis for the filter.

    Worked perfectly.

    LVL 2

    Accepted Solution

    Closed, 125 points refunded.
    Friendly Neighbourhood Community Support Admin

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now