How do I copy table Rows with VBA

[GreenFella]

Howdy.

I have a situation where information being entered into a database via an Access form needs to be copied any number of times.

The customer information resides in three seperate tables. A user selected number will dictate the number of copies that are required.

The customer table is the main table with the other two tables being on the Many side of the relationship to the Customer record.

So the Customer record needs to be copied, followed by the information in table two then the information in table three.

The one catch is the key information for newly added customer record needs to be passed on to become part of the key for the other two tables.

Any help would be greatly appreciated.

TIA
Greenfella

 

[zevw]

I am not clear if the customer this info a form, where is this data being stored.

If it is being stored in a table the just run a append query with a loop the number of times the user specified and it will be that amount of times in the table.

I don't exactly understand why should you need the saame info more than 1 time in a table.

Please elaborate!

 

[zevw]

I am not clear if the customer info is entered in this form, where is this data being stored.

If it is being stored in a table then just run an append query with a loop, the number of times the user specified and it will be that amount of times in the table.

I don't exactly understand why should you need the same info more than 1 time in a table.

Please elaborate!