Repeating Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an macro that runs whenever a new record is added to a main form. The
macro automatically adds a new record into the subform with standard default
values.

This feature is working fine, but it only inserts one record into the
subform. I have a field on the main form that tracks [number Of Containers].
I want the number of records that are automatically added to the subform to
match the number the user entered in the [number Of Containers] field on the
main form.

For example, if the user typed a 3 in the [Number of Container] field on the
main form, I would want the macro to repeat 3 times to insert 3 records into
the subform.

Right now the macro keeps running endlessly & adding records until I halt
the macro.
Please Help.
 
Williams,

You can make another macro, with the RunMacro action, to run your
existing macro, and in the Repeat Count argument you can put...
=[Number of Containers]
 
Back
Top