Copying Mutiple Recordsets To Different Tables

[hascons]

Hello,

I have an estimating database. Which generally gets data from 4 different Tables.
I Have a form with a Bound main form and 3 Bound subforms to get this data
This has been working well.

There are times that I need to create an Identical Estimate for different customers. I now manually copy the information from each of the tables and paste to the bottom and change the JobNumber (as this relates each table together) and the customer.

I would like to create a sub that would do this instead of doing this manually and tie this sub to a command button on the form.

My question is what is the easiest way to copy the recordsets to the bottom of each table.

 

[MStef]

Try to do this via "Append Query".

 

[hascons]

Mstef,

I was able to figure this out using a DAO procedure to add the records.

Thanks for your response