[MS Access Question] FROM SQL Statement

[Browni]

I am trying to create a way of taking a reccord from one table and move it into another, after selecting the reccord from a form. I have tried a append query, no luck. I stubled apon the INSERT INTO statement, my attempt is below:

INSERT INTO Cadet_Archive
SELECT DistinctRow
FROM tbl Cadet
WHERE Name of Applicant =  Forms![frm Cadet]![Combo64]

I keep getting an error Syantx Error in INSERT INTO statement, the FROM entry is highlighted, indicating that that is the problem (?)

Any help you can give is appriceated.

Adam

PS: I know this is a PC program/problem but i wasnt sure where to post it.