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.