I need to copy the records of a query result to an existibng table and have the code below but it keeps error'ing with Run time error 3061, Two few parameters, expected two.

Any ideas where I am going wrong please - my code is this:

CurrentDb.Execute "Insert Into TBL_Balance SELECT * FROM Qry_DDRListSelected"

With TBL_Balance the table I need to copy the records from using the query (Qry_DDRListSelected) which links to another table TBL_DDR.