tranfer data from one table to another

[kabir_hussein]

Hi

Does anyone know of a way of transfering data from a form which i have just entered data into then when i click on save i want the data saved onto another table.

This is because i want one table to keep data when it is first entered and the original table will have data that may or may not be altered.hence for calculation purposes i want to two tables so i can compare with how the data was originally and how it has been changed


thank you

 

[Mile-O]

An APPEND Query would best here. Especially if you store the DateRecorded for each record.

 

[kabir_hussein]

Hi

i have been trying to append a query but i keep on getting the same error message saying that "duplicate output destination partID"

do you know why i am getting this message


i have attachhed a picture of the two table i am trying to append

 

[kabir_hussein]

sorry my attachment for some strange reason dont attach on the actual forum

 

[Mile-O]

Double Post.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=58597