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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...

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?
 
Back
Top