The following SQL statement will add the entire record (ID: 30) from CustomerT to CustomerTempT.

    CurrentDb.Execute "INSERT INTO CustomerTempT SELECT * FROM CustomerT WHERE CustomerID=30"

Notes:
Make a copy of the source table (CustomerT) and save with Structure Only.
Open the destination table (CustomerTempT) change the ID field from an AutoNumber to a regular Number data type (to prevent a Key Violation error).

Thanks Kevin I wrote your code in a button and it worked but when I modified the where condition it says:
Expected: End of Statement.

CurrentDb.Execute "INSERT INTO AntikroppT SELECT MasterID, AntikroppsNamn, Sp'dning FROM MasterComboQ WHERE "MasterID=" & MasterID"

Thanks!

You have an extra double quote on the end.

Thanks.