I need a code that deletes a record from one table and copies the content of this record to a new record in another table.
In my case the tables are TblClients and customers. In the form frmClients I have a control with which I may copy the content of a certain client to a new record in the form Fcustomers , after that delete the record and open the form Fcustomers to the already created customer.
As could be seen from the attachement, I use INSERT INTO statement, there is some
Mistake in it, and also I do not know how to open the second form exactly to the newly created customer.
Can you help me ?