Why would you pull the componentID from [copy of 8partT]? Shouldn't this be the componentID selected in unbound combobox? Also, need to specify table to select from and filter criteria.

strsql = "INSERT INTO [comppartT]( [componentID], [partID] )"
strsql = strsql & "SELECT " & Me.comboboxname & " AS ID, [partID] FROM [copy of 8partT] WHERE [yes/no fieldname] = True;"