Unanswered: Select summary record subform1 and display full record subform2
I'm struggling to find an answer to this one short of what I already know.
Previously I have had summary records on a continuous subform and clicked on it to open up the full record in a new form or pop-up form. Nothing stopping me doing that but I'm trying to be a bit cleverer than that this time if at all possible.
This time my main form has both a summary data subform and a main record subform bound to it. Basically, click on the summary record in one subform and display the main record in another subform. My problem is setting focus on the 2nd subform and applying the condition without the functionality of the open form command.
The Collection references are [Forms]![frmSchool]![sfrmPupilBulk]![Pupil#] for the first subform and [Forms]![frmSchool]![sfrmPupilIndividual]![Pupil#] for the second.
Thanks DC. I had a job getting that working but came up with a simple method in the end. Simply to have an unbound text box on the main form and have the Pupil# value pushed to the text box when the particular record was clicked in the summary subform. That then enabled me to use the link Parent/Child fields function on the subform displaying the full record. Bish bash bosh- job's a good'n!