Populating a "pop-up" form from a subForm

[Guest]

I am a new comer...I am building a Main form with a subform. The subForm is
in datasheet view with multiple records. I put a cmd Button on the Main form
that on_click opens (pops up) a new form and populates its fields from the
subForm. Currnently the pop-up form and subForm are receiving the correct
data, but always shows the first record of the subForm, no matter what record
in the subForm is selected. My problem is that I would like the pop-up form
to show the record that has focus, so if I select another record in the
subForm, it will populate the pop-up form. I have been struggling with this
code, so any help or suggestions are well appreciated. Thank you.

 

[Guest]

I would like the pop-up form to show the record that has focus
The subform no longer has focus when you popup a form.
You need to store the data in a textbox on the main form (not visible) and
then use it as criteria in the query/record source selection statement for
the popup.

 

[Guest]

Thank you...that was a perfect solution.