Problems with Subform displaying records

[Astron2012]

Hi I have a mainform with 2 subforms with different data sources (queries).

The first one is working fine but the second subform does not show any records (when it should) when the form initially opens.

It is only when I switch to design view, then switch back to form view that it will display the records.

I have checked and it isn't any code that is affecting it as I removed the little bit of code I had for it and it still didn't work properly.



Really strange, any ideas??

Thanks

[June7]

Want to provide db for analysis? Follow instructions at bottom of my post.

[Missinglinq]

Are both Subforms linked to the Main Form, or is the second Subform linked to the first Subform?

I suspect that this is one of those cases where posting the file, as Paul suggested, so that people here can get their hands on it, is going to be the only way that we can help.

Linq ;0)>