1st form's current sel record on 2nd form

[State]

I have a QBF form (Form1) which displays a subform of records (in "Continuous Forms" view). I have a "More Details" button on the
subform which opens another form (Form2) which I would like to display additional data (from same query) for the current selected record on the subform. I do not know how to "capture" the currently selected record in the continuous subform for Form2 to use. I have tried to emulate the Microsoft Developer Solutions form example (CustomerPhoneList form with "More" button) to try to capture and use the query's current record number for Form2, but have been unsuccessful. I have also tried capturing a unique ID field that each record has for the current selected record in the continous subform with no luck.
Any assistance of an example would be greatly appreciated. Hopefully, this is an easy one!

pAuL

 

[State]

Actually, now that I think about it, I would like to capture two selected records from Form1 (continuous subform on Form1) to display side-by-side on Form2. This would allow a user to compare each record. I am still trying to figure out how to capture/reference a selected record from a continuous form subform. Thanks.

Paul

 

[NSTLouis]

I am having the same issue, only trying to capture the field to filter the underlying query so that I can use a macro to jump straight from the form to the report. Any ideas on how to design a command button or a macro to accomplish this?

 

[State]

The reason why I am attempting to do it this way is because I have approximately 40 fields that the user needs to view and compare with record1 and record2. I first tried to list all 40 fields in a subform, but the max width is 20". Next, I broke down the 40 fields into 5 groups and attempted to tab them in the subform.