Copying data from subform to main form

[Roger]

I am trying to create a very simple MRP data base for my business.
In doing so I need a data base that contains my poduct numbers and each of
these product numbers is linked (somehow) to a purchased part material list
data base that holds which purchased parts are used for a given manufactured
product number.
I planned on creating a data base of all purchased parts and then use this
in a subform manner within a material list form for a given manufactured
product.
The problem I am having is that when I open the material list form and
scroll through the purchased parts subform for the part I want, I can't seem
to get the material list form to accept the input from the purchased part
subform. Oh I can display the selected item in the material list main form,
but I can't seem to get the main form to accept it and move forward for a new
purchased part to be selected and enterd.

 

[BruceM]

Are you saying the products are manufactured from purchased parts, and that
you want to be able to populate the parts list for a given product? If so,
a product may consist of many parts, and a part may be used in many
different products, I expect. If so, you need three tables.

tblProduct
ProductID (primary key, or PK)
ProductName
Description, etc.

tblPart
PartID (PK)
PartName
Description, etc.

tblProductPart
ProductPartID (PK)
ProductID
PartID
Quantity

If the information about a Part includes Manufacturer you will need a
Manufacturer table too.

Build a form based on tblPart, and populate it with all the Part information
you have.

Build a main form based on tblProduct, with a subform (Continuous view)
based on tblProductPart. On the subform, bind a combo box to ProductID.
Use tblPart as the combo box Row Source. When you select a Part from the
combo box it will be added to the Part List for the product in the main
form.

This is just a sketch, since it is not entirely clear this is what you
intend. If it is not, please clarify.