Looping in data macros???

[Rafegh]

Is it possible to have a loop on a data macro? Think that in one table I insert number 5, can access make exactly five records in another table?

[June7]

Looping in a macro is not easy - maybe impossible with Data Macro.

Bing: Access macro loop
http://support.microsoft.com/kb/90815

[NTC]

This would be done with an Append Query; you would need a control table that consists of only integers in sequence beginning with 1 and continuing to the highest number you app will ever require. Then you build it by applying the criteria of <=5 to a Select Query against your control Table which will result in 5 records. Then you join that to your data - and then write it into the table using the Append Query.