Browni
Registered
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:
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.
Code:
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.