I need a little help here. I have an expanding table that has a nested (also expanding) table in it. The header row contains a user-entered project name. The nested table contains milestones for each project. I have a button used to move the completed project to an Archive page. Currently, I have the button executing 3 tasks:
1. Add a new section to the Archive table
2. Copy the contents of the Project table to the Archive table
3. Delete the contents from the Projects table.
I can add a section to the Archive table, but it only copies the first line - the subsequent expanded lines are ignored.
I have been through the previous questions on this topic, but although similar, I cannot get them to work for me.
So, I need to add this:
I have this code on the Click event of the green Archive button:
If you dont want to go down the often confusing route of 'for statements', what you have would be placed in a button click. If you want to do multiple rows at the same time, you will have to write that code in as well. I have done that before. If your subform is limited to the amount of rows that can be added, you only have to write a finite amount of code.
Many thanks for taking a look at this. As I said in my original post, I'm very much a newbie at this, so forgive a dumb question (or three!) - does this code REPLACE mine or is it in addition to it? I replaced it, but no joy. If it's in addition, where does it go?
I've just realized that I didn't post it. So here is my original work, broken down into the three steps: