Access 2007 form not displaying records correctly

Posted on 2009-02-10
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.
Question by:sqlagent007
LVL 44

Expert Comment

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

Accepted Solution

sqlagent007 earned 0 total points
ID: 23607880
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

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

839 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