Save a record to a different table

[blackbeltrrf]

I have a problem that seems easy enough but I can't figure out how to do it.
1. I have a form that pulls from several tables from our MRP system.
2. I need to build a new end item part number from parts in our system.
3. What I want to do is pull a certain record by part number and get all the costing information. (That I have and works fine)
4. I want to then be able to save that record into a new table with a unique identifier then choose another part and save that into the same table as the first with the same unique identifier...etc...until I build the new part number with all the components that make up the new part number in the table. (This is what I am having trouble with)

5. Once I have this in the new table I can then query the new table and get the total cost of the new end item part.

Any help would be greatly appreciated on how to save the current record to a new table.

Thank you in advance for the help

 

[JamesMcS]

You could build a make table SQL string into your VBA code, using variables from the form for the contents of the fields?

 

[blackbeltrrf]

TYVM for getting my brain thinking. I worry myself sometime I got it using a Command button:

Private Sub EnterPNcmd_Click()
Dim SQL_Text As String
SQL_Text = "INSERT INTO costingresultstbl (enditemnumber,PN,Enditemcustomer,comments,currentcost,currentmatl,currentlabor,currentoh,ohrateinput,laborrateinput,description,Laborhours,labordollarscalc,ohdollarscalc,PartType) SELECT '" & Me.EndItemtxt & "','" & Me.ItemMasterPNtxt & "','" & Me.Customer & "','" & Me.Commentstxt & "','" & Me.CurrentCosttxt & "','" & Me.Materialtxt & "','" & Me.Labortxt & "','" & OHtxt & "','" & OHRatetxt & "','" & LaborRatetxt & "','" & Descriptiontxt & "','" & LaborHourstxt & "','" & LaborDollarstxt & "','" & OHDollarstxt & "','" & Frame238 & "'"

DoCmd.RunSQL (SQL_Text)
End Sub

Thanks again.