I figured it out! Thank you for pointing me in the right direction.
InsertSQL = "INSERT INTO tblRA ( [ProposalID], [ProductID], [ProductConc], [Stage], [Description], [Volume])"
InsertSQL = InsertSQL + " SELECT tblRA.[ProposalID], tblRA.[ProductID], tblRA.[ProductConc], " & NewValue & ""...