Ok, I got this to work.
I created an append query; this is the SQL code for the query.
INSERT INTO History ( [Item #], [Part #], [Item Description], Stock )
SELECT [Forms]![Output Calculations].[Item #] AS [Item #], [Forms]![Output Calculations].[Part #] AS [Part #], [Forms]![Output...