PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
Course Of The Month
2 days, 9 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Access Subform doesn't show underlying Data
Posted on 2012-12-27
I have the most bizarre thing happening. I have Form Called Sponsors with a Subform of Sponsor Addresses. The parent /child link is correct.
If you open the Sponsor form, you see no addresses.
However, if you filter on the SponsorID, the addresses appear in the subform.
Mystery??? why?
If you open the Sponsor form, you see no addresses.
However, if you filter on the SponsorID, the addresses appear in the subform.
Mystery??? why?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3-
3
7 Comments
Can you post more details please?
You may have to put an action after the parent form loads to refresh the subform.
AielloJ
You may have to put an action after the parent form loads to refresh the subform.
AielloJ
Perhaps the Main form has a little corruption creeping in...
Have you tried compacting the db?
As another quick test, just make another Sponsors Main form, and drop in the subform.
What happens in the new main form?
Have you tried compacting the db?
As another quick test, just make another Sponsors Main form, and drop in the subform.
What happens in the new main form?
I can't post the database, because it a regulatory database for government studies.
I did try to put both a requery and refresh on the Main form on the Form_Activate. It doesn't do anything.
I attached a document to show you what I see :
I did try to put both a requery and refresh on the Main form on the Form_Activate. It doesn't do anything.
I attached a document to show you what I see :
<I can't post the database,>
I never asked you to...
I only asked for :
"a simple sample db that illustrates this issue"
So as log as the simple sample exhibits the same issue, we can troubleshoot .
I also asked:
Have you tried compacting the db?
As another quick test, just make another Sponsors Main form, and drop in the subform.
What happens in the new main form?
I never asked you to...
I only asked for :
"a simple sample db that illustrates this issue"
So as log as the simple sample exhibits the same issue, we can troubleshoot .
I also asked:
Have you tried compacting the db?
As another quick test, just make another Sponsors Main form, and drop in the subform.
What happens in the new main form?
Featured Post
For Any Use & On Any Platform
Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
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.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:
Set the “Repeat Section” property of the dummy…
Suggested Courses
Course of the Month2 days, 9 hours left to enroll
719 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.