I have a form that is linked to a subform and the subform is based on
a table's query.
I'd like to put a textbox on the form and have the user enter a number
in this text box. Then the user would enter a new record in the
What code could I use as an After update so that the number is taken
from the Form's textbox and then that many identical records minus one
(identical to the new record just inputted) are appended to the
So if number 3 is input, after the new record is entered, two new
identical records are appended to the subform.
If number 1 is input, then zero new identical records would be