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

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...