Copy data from form to form by clicking a button

[tswack]

I have created a table and a form, both named Customer Database to keep track of device repairs to log all of the information I need. Recently, I thought it would be a good idea to create a table and form to keep track of estimates because not all people who ask about getting their phone repaired, actually do it. People have asked me about how much it would cost me to fix a broken device and I would give them estimate.

Getting a lot of customers, I have made a table of all of the estimates and then created a form named Repair Estimates with fields (First Name, Last Name, Device, Problem, Problem1, Estimate). If a person I had given an estimate too actually wants their device fixed, I'd like to be able to code a click a button to copy the fields from the estimate record (First Name, Last Name, Device, Problem, Problem1, Estimate), to a new record with the same fields in "Customer database" table so I don't have to retype them and then it deletes that record from "Repair Estimates". After it copies the data from that record, I would like it to automatically take me to the new record it created, so I can fill out the rest of the fields in "Customer Database". Any help on how to do this would be greatly appreciated.

[June7]

This means running SQL INSERT and DELETE actions.

Then more code to open form or requery form and move to record.

[tswack]

This means running SQL INSERT and DELETE actions.

Then more code to open form or requery form and move to record.

I'm just a beginner at Microsoft Access. How do I do this?

[June7]

An easier approach would be one table with a field to classify the record as Estimate or Final.

Create customer record regardless if the request is Estimate or Final.

Otherwise, start learning programming - http://office.microsoft.com/en-us/ac...010341717.aspx

Here is one method to find an existing record http://datapigtechnologies.com/flash...tomfilter.html