Populate new form based on selection from previous form

[Guest]

Once the user makes a selection from a continuous form, he double-clicks on
the selection, and I would like a second form to come up that is populated
with the details (parts) for the item selected on the first form. For
example, the item selected on form1 consists of from 5 to up to as many as
40-50 parts. Once the second form opens, the parts for the selection would be
on the 2nd form (continuous form?). Also, I would like the user to then be
able to add additional parts beneath the parts on Form2 (additional options,
etc.). What is the best way to do this?
Thank you so much for your help.
Louise

 

[kingston via AccessMonster.com]

Try using a sub-form instead. This eliminates the need to display (and store?
) data twice. Open the main form in design mode and drop the subform into
the Details section. Specify the fields that relate the data and you're done.
Here are the steps in brief:

1) Create main form from main table with ItemID.
2) Create subform from secondary table with ItemID that refers to main table.
3) Drop the subform into the main form in design mode and specify ItemID as
the link.