Link two forms to display related data

[KrisDdb]

I have a main form with a list box that has 7 fields, which get their values from a query (the query returns 10 fields in total out of which I am using only 7 to populate the main form). Out of these 7 fields, there is a unique field “key_no”. Now I am trying to open a second form which would have details of the remaining 3 fields (out of the total 10 from the query). The catch is, I want the second form to display only one record’s field values, the record being the one selected from the list box on the main form. I want the second form to open as a pop up (can be avoided if not possible) and also be able to be edited and saved with new data input by the user. This second form would open up when a record is double clicked in the list box on the main form. I am not able to figure out how to link both the forms.
Please give me some suggestions. Appreciate your time and thoughts.

[pbaldy]

How about this?

BaldyWeb wherecondition

[KrisDdb]

Hey Paul.. Thanks for the quick reply.

I tried something similar. Heres the code for it:


Dim stDocName As String

stDocName = "frm2"
DoCmd.OpenForm stDocName, , , "key_no = " & Me.key_no, acFormEdit, acDialog

I put the above code in the double click event procedure for the list box (list23). The unique field name is 'key_no' on both the forms. But still the frm2 is displaying the wrong data. Where am I going wrong?

Edit: oh and the key_no is a unique number.

[pbaldy]

The wrong data, or all data? Do you know how to set a breakpoint and check that Me.key_no is returning what you think it should? Can you post the db? Oh, and I would expect Me.Key_no to be Me.list23, so it got the value from the listbox. As is, it's getting whatever record is displayed on the form.