Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 266
  • Last Modified:

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?
0
sharpapproach
Asked:
sharpapproach
  • 3
  • 3
1 Solution
 
Jeffrey CoachmanMIS LiasonCommented:
Could not replicate...

Can you post a simple sample db that illustrates this issue?
0
 
AielloJCommented:
Can you post more details please?

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

AielloJ
0
 
Jeffrey CoachmanMIS LiasonCommented:
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?
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
sharpapproachAuthor 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 :
0
 
Jeffrey CoachmanMIS LiasonCommented:
<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?
0
 
sharpapproachAuthor Commented:
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
0
 
sharpapproachAuthor Commented:
This is how I got it to work...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now