How to transfer the data to another table and then then delete them ?
Can somebody help me with my task? I have to solve the following problem.I have to find a client from the form frmClients, based on the table tblClients,
then open another form called FCustomers, based on the table customers,and in the new record insert some of the fields as Company,LastName and city,and after that delete the client from the form frmClients.The idea is that after a client has become a customer, he should exist no more in the table tblClients and appear in the table fCustomer sunder a new number.Both tables have an Autonumber.
First i chose the client in the form frmClients, and then in a control of that form I am opening the other form like that:
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "FCustomers"
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.GoToRecord , "", acNewRec
After opening the form FCustomers with a new record, i want:
1. insert the fields Company, LastName and city which are common to the two tables
2. delete the client from the table tblClients.
How can i delete the client under question and how can i insert the values of the client under question to the new customer?
I preferred to state the task what must be achieved instead of telling of my unsucsefful efforts,since they will be of no use to anyone,
but the solution i may have may be sound and interesting to everybody.