Access 2007 form not displaying records correctly

Posted on 2009-02-10
Last Modified: 2013-11-28
I have worked through these in the past with access 2003, however I am way out of practice. With access 2003 I was able to go to the form and see all the code within the form, then work backwards from there. I have attempted this in 2007, but I am failing miserably.

Here is my issue, when I load the form, and record 1 is displayed and the "Actions Detail" grid is blank. The users claim this should have plenty of activity in the actions grid like screen shot 2.

When I move to record 2, the "Actions Detail" grid is populated and everyone is happy.

So now I need to figure out where the "Actions Detail" is pulling it's data. How can I figure out what table it is pulling from?

The users also mentioned to me that the access developer would fix this quickly with "linking" the data back. I am guessing that means updating a foreign key value.

Please help me figure out how to find the root cause of this issue. I am lost when it comes to access and of course...this lady no longer works with the company. I will be willing to post any code in the forms needed to help solve this issue.
Question by:sqlagent007
    LVL 44

    Expert Comment

    Notice the top left hand corner of your first shot, New - meaning your form is set for adding records, not editing or adding.
    LVL 1

    Accepted Solution

    So I figured it out, what I needed was to get to the VB code behind the form. In 2007 it is: "database tools" then "visual basic". Once I figured that out in Access 2007, I was able to find that in order to pull the records into the "ACTION DETAILS" grid, the form needed to perform a join on DOCKET NUMBER.

    They key was to get to the VBA code, then find the value of [stLinkCriteria = "[DocketNo]=" ]

    I only posted my steps to share in the event that somebody else has a learning curve with Access 2007.

    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    Suggested Solutions

    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    755 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

    22 Experts available now in Live!

    Get 1:1 Help Now