Repeat Subform last field entry x amount of times using command button
Okay so I have a "table1" and a "table2". Table1 has a primary key autonumber which is one to many into table2, a date and a type field which has two defined lookup options. table2 only has the primary key from table1 as a number input and an ID field which is linked to table3 which contains the ID as a primary key.
So when I created a form for table1 it creates a main form and a subform using table2's only remaining field "ID". Perfect, here I can enter multiple IDs into a single table which creates multiple records automatically in table2.
Now I would like a button that would repeat the ID entry in the subform 5 times, preferably using VBA and I have no idea how to do it,
Once again, repeat the last entered field in the subform 5 times using a button
Last edited by hooolagon; 05-07-2017 at 05:15 AM.
Reason: Add database