Good idea, but I tried that already. It works as far as opening the second form and changing the result in that form, but then I have two windows open and one disappears behind the other and I have to reclick each time to open the form.
There has to be a way to change the record in that second subform...
Firstly, I use Access 95 and if you are using a much later version some of the macro actions maybe different names.
The FindRecord action is essentially using the "binoculars" via a macro action.
=[Forms]![MasterForm]![Text1397] (you will need to add the subform name as well for the correct reference) is placed in the FindRecord will find a record which has in the selected field a value the same as Text1397.
The matching record you want to find in Subform 2 should have some for ID that matches the record in Subform 1. I use a field which I call NameNumber and I will use that here as it is in mind!!
So let's say the record in Subform 1 has a NameNumber value of 12345. Thus you want to find the record in Subform 2 that also has the NameNumber value of 12345.
To Subform 2 you add an unbound text box, which in my case is called Text1397.
The first part of the macro action uses SetValue to set the value of text1397 on Subform 2 to be equal to the value of the NameNumber field on the selected record on Subform 1.
The next macro action is to SelectObject and that is your Subform 2. The next macro action is GoToControl and for me that would be NameNumber.
Then comes FindRecord which for me will be
Thus it finds the record in my Masterform where the NameNumber is the same value as Text1397.
If it helps I can print out the macro actions from the macro and scan them and email you the PDF file