How to update and add that record at the same time?

[Andy Chettiar]

I have an update form which selects a partucular record from Company Name and it undergoes the editing and gets saved in the table .

I want to add a copy of that updated record also in the same table or in a seperate table after i click the update button in the Update Form.

Is there any possibe solution for this

AC.

 

[John Vinson]

I have an update form which selects a partucular record from Company Name and it undergoes the editing and gets saved in the table .

I want to add a copy of that updated record also in the same table or in a seperate table after i click the update button in the Update Form.

Ummm...

WHY?

Storing data redundantly is almost never a desirable operation. You
can open a Recordset and add the data to it, but it is very rare that
you would want to do this. Could you explain?