Error either EOF or BOF is true when I can see a record in the table

Posted on 2011-10-19
Last Modified: 2012-05-12
I am using a recordset that is based on a table that I populated through a subform. I keep getting the above error, but when I look in the table there is a record sitting there.
Question by:smm6809
    LVL 56

    Expert Comment

    by:Jim Dettman (Microsoft MVP/ EE MVE)

     Does the form have a filter applied?

     Did you try stepping through the code to the point of the error to see what's going on?

     It would help to see the code.

    LVL 61

    Accepted Solution

    Without seeing your code, I'd suggest:

    1.  Add the following before any recordset code to ensure that any currently edited records get committed to the table:


    or if the recordset code is on the mainform:


    2.  Try a requery statement before the recordset code (and after it if it is writing data that might affect your form's recordsource):


    or if the recordset code is on the mainform:


    Author Closing Comment

    Thanks! worked great

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    779 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

    18 Experts available now in Live!

    Get 1:1 Help Now