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 Coachman
<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?
Can you post a simple sample db that illustrates this issue?