Why don't sub forms link correctly on opening

[Cliff44]

I am using Access 2007 linked to SQLserver tables
I have a sub form that links to an intermediate form on a main form, when I first open the main form the link between the main form and the intermediate form is not established until I select the next record on the main form then it links to the correct records fine.
Why should this be and how can fix it?
There are no problems with the link between the intermediate form and the sub form.

[missinglinq]

Does the first record on main form have a corresponding record on the intermediate form?

Linq ;0)>

[Cliff44]

Yes it has and when I move on to the second record and then go back to the first it is linked correctly.

[nico5038]

Guess you'll ned to force Access to process/requiry the subform.
Try in the OnCurrent event:

Me.subformname.SourceObject = Me.subformname.SourceObject

This should force Access to activate the needed table.

Nic;o)