Good day All,

	I have a data base where I have the main table and the archive table I 
want in case of I pressed the archive button on the form all the data of 
this record to be moved to the archive table and to be deleted from the 
main table.

Best regards,

Ahmed Khamis
Vodafone Egypt
Customer operation
Mob:  xxx-xxx-xxxx
Ext:56-1107
Ahmed.khamis@v...

Ahmed,
   I usually do this by creating an append query that will append the data 
from the main table to the archive table and create a delete query using 
the same criteria as the append query.

Thanks,
Derrick Flores

>>> Ahmed.Khamis@v... 07/22/02 12:13PM >>>

Good day All,

	I have a data base where I have the main table and the archive 
table I want in case of I pressed the archive button on the form all the 
data of this record to be moved to the archive table and to be deleted 
from the main table.

Best regards,

Ahmed Khamis
Vodafone Egypt
Customer operation
Mob:  xxx-xxx-xxxx
Ext:56-1107
Ahmed.khamis@v...