Access 2010

Posted on 2014-08-27
Last Modified: 2014-09-01
I have created a form in Access 2010 that consists of two subforms. One of the subforms finds items when I search. The other subform does not find any items when I search even when I know that the searched for item exists.
Question by:John_Holecek
    LVL 30

    Expert Comment

    Search in one form works fine, but in the other one it fails.

    One reason could be a logical error with a wrong where criteria.

    Try with a new form with one field and check the code. This may pinpoint any logical error.

    You may need to recreate that form. Recreation is one way to clean up any logical mistakes.

    If it is feasible,  you may upload a database with just the 2 forms including a few records of test data.
    LVL 10

    Accepted Solution

    Hard to understand what you mean by subforms being linked to search lists. How?

    Here's a white paper we wrote that may help:
    Synchronize Two Related Subforms on a Microsoft Access Form

    Here's another white paper on a related issue about defining the link fields:
    Microsoft Access Subforms Should Reference the Control Rather than Field for Master Link Fields

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Suggested Solutions

    Outline Suppose you have some simple text based data in Excel that you would like to display as a PowerPoint presentation. Of course it would be possible to write some fairly complex VBA code that created a new slide for each line of the Excel data…
    This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
    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.
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    759 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