Subform issue - not refreshing.

[andy1968]

I have a form with 3 subforms that are linked by the one key field.


The subfroms are located on a tabControl


I open the main from from another form with a where clause.


Only one of the 3 subforms displays the related data. The others are empty.



If I change the view of the form to design view, and then reopen it, the subforms populate just fine. Moving to a new record and back does not have this same effect.


I have tried:


Me.subfromname.Requery from the on form load event without success.


I also tried Refresh - no luck

 

[theDBguy]

Hi. We may have to see if first hand to be able to say why.

 

[andy1968]

I'll send you something ASAP

 

[andy1968]

Well, shoot.


When I exported the offending forms to a new database, it worked just fine.


I'm at a lose.

 

[theDBguy]

Well, shoot.

When I exported the offending forms to a new database, it worked just fine.

I'm at a lose.

Try comparing the two to see if you can find any difference. If not, try re-importing the working copy back into the original file.

 

[andy1968]

Imported it back to the original database and it did not work.


I'm attaching the sub database.

 

[andy1968]

Ok - the issue has to do with me having the filter on load for the subforms set to yes.


Turned it off and all is well.

 

[theDBguy]

Ok - the issue has to do with me having the filter on load for the subforms set to yes.

Turned it off and all is well.

Hi. Glad to hear you got it sorted out. Good luck with your project.