asked on
Access Subform doesn't show underlying Data
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?
Microsoft Access
Last Comment
sharpapproach
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?
ASKER
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?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
This is how I got it to work...
Can you post a simple sample db that illustrates this issue?