We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now


Access 2007 form not displaying records correctly

sqlagent007 asked
Medium Priority
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.
Watch Question

Notice the top left hand corner of your first shot, New - meaning your form is set for adding records, not editing or adding.
Technology professional
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.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.