Move Info from One Table to Another
This code is part of the answer to an MS Access question on AWF.
The first answer demonstrates the INSERT INTO method of adding records to another table. This method is where you update the underlying table by adding a new record directly into the table. However, this makes a fixed record, the whole record is added, and if you don’t want to record ALL the details added, then you have a lot of editing/deleting to do.
The second answer demonstrates a method of adding the records through a form, straight into each textbox on the Form, the text-boxes that relate to the underlying data in the table. This method sets the textbox default value. Now you can see the information and vet it without saving it to the table. This has a distinct advantages when you’re doing data modification.
More Info on Nifty Access Website HERE:-
https://www.niftyaccess.com/move-info-from-one-table-to-another/
You get to two Forms. Insert INTO SQL Statement Form. Textbox Default Value Example Form...