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
Thanks
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
Thanks
Attachments
Last edited: