Want to archive records from 1 table to another by using the INSERT INTO sql in my form by clicking on a Archive command button, the record must be save into the archive table.
using : INSERT INTO Archive(Name, Surname) FROM SELECT Name, Surname FROM Addresses.
Must i declair a variable doens't want to word with my command button...
using : INSERT INTO Archive(Name, Surname) FROM SELECT Name, Surname FROM Addresses.
Must i declair a variable doens't want to word with my command button...