Hi Bruce,
Thank you for responding. I do not know how to attach the form to show you. (is this possible?)
I tried your script above but nothing happened.
I gave an example in my initial question above however the real table numbers are below.
When filling out Table5, it copies the data to Table21.
When clicking on the add row button in Table5, a new row is added to Table5, and a new row added to Table21.
When filling out the new row in Table5, the data is not copied to the new row in Table21. It changes the last row in Table21.