In the attached example, which I actually got from another expert, there a 3 subforms used in a master form "F__PPSAccounts". When I open this form it shows the first record of subform "S_ContractYears" and the first record of "S_Guarantees". But the other subform "S_RevSharePmts" doesn't show any records, even though for the combination of the other 2 subforms it should show 4 records. It is not until you click on the second record on "S_Guarantees" then back to the first record that it displays and records.
I need the 3 forms to show the relevant records as soon as the form is open. So in the attached example, when you open the
"F__PPSAccounts" form it should show:
2 records in "S_ContractYears" (416 and 417)
2 records in "S_Guarantees" (15 and 16)
4 records in "S_RevSharePmts" (27, 28, 29 and 34)
It's OK when you click on the second record in the "S_ContractYears" subform, but I need it to be correct as soon as you open the main form please