Access Subform doesn't show underlying Data

sharpapproach
sharpapproach used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
Could not replicate...

Can you post a simple sample db that illustrates this issue?

Commented:
Can you post more details please?

You may have to put an action after the parent form loads to refresh the subform.

AielloJ
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
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?
11/26 Forrester Webinar: Savings for Enterprise

How can your organization benefit from savings just by replacing your legacy backup solutions with Acronis' #CyberProtection? Join Forrester's Joe Branca and Ryan Davis from Acronis live as they explain how you can too.

Author

Commented:
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 :
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
<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?
We tried everything.  I even recreated the form.  I finally recreated in a different database, did an import and worked.... Been an Access programmer for 20 years and never saw this.... Very bizarre

Author

Commented:
This is how I got it to work...

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial