Copy parent and child tables into new records on them

[Chrelske]

All in advance thank you for helping me.

I have a project database in MS-Access 2013 64bits.
Most of the time when i had a question i looked it up in several fora and there always was a solution for my problem.


But this time I've looked everywhere but I have so far found no solution.

So i hope that someone can help me out in this.

In my project database, I have a form with several sub forms.
Behind every form is a table. All tables have a one to many relationship.
For each subform a have Letter signed to it.(just to make it clear which table in connected to which subform)
And on the form i also put this letters to the specific subforms.






What I want to achieve now is that when I have select a record in Form A and then I click the copy button,
all the records are copied from all the subforms in a new record in the same project.
In other words, a new record must be added in Form A , with all the data that were also present in the old record,including all the records from the child table.

I really don't know how to achieve this.
I think the only way is to do this is with VBA.
VBA is no problem, i have work with this several times(I mean, I have copied various codes used in the past.
Personally I'm not a programmer but it does nevertheless always workt to use it in my database).

So finally if there is anyone who can help me, then I will really appreciate.

Best regards,
Chris van der Haar(the Netherlands)

[ranman256]

you would build a macro with lots of queries.
Q1 would copy the master record,
then you must grab the NEW key value on this new record.
Using this key, you would select the child records from the old key and post new records with the new key.
etc
etc.

[pbaldy]

Perhaps:

http://allenbrowne.com/ser-57.html

[Chrelske]

Hello ranman256,

The problem is that i don't know how to make een query that holds for example 2 or 3 ID's for the new to make child records(who also each have 5 records)
So i have to loop true several records in the master table to catch the id's. (which should then be placed in memory to use them later).
That is exactly my problem, I am not able to know how to do that.
Is it possible to maken a query that hold's 2 or 3 id's to use later on?