Need Expandable Form/Template

We have a template that has 7 fields accross the top of the page for part information, and then 27 rows underneath it with 3 fields accross each row. If we need more than 27 rows, we have another template that is two pages that has the 7 fields accross the top of both pages, and rows 1-27 on the first page to rows 28-54 on page two. This continues for a total of 14 differnt templates.

I am trying to find a way to create ONE form that will expand it's number of rows if you need to keep typing.

Who is Participating?

Record a macro of yourself creating a new page of rows. (you can use an autotext entry even, if you copy it to the template)
Do a on-exit of the LAST form field in the existing template that throws up a message box that says "would you like another page of this form?" and Yes/No buttons. Yes runs the autotext entry. No just closes the msgbox.

If you select your first row of 7 fields and select: Table - Heading Rows Repeat, then that row will automatically repeat on every page
I am assuming that the first row is contiguous with the other 27 rows and that there's no paragraph break in between...

And if you don't need exactly 27 rows on the subsequent page, the user can just tab out of the final cell and it will create a new line of 3 cells on the next page with the 7 cell header line above it. They can keep tabbing away until they have enough lines.

I cannot try your answers yet. We were affected by the hurricane and have no power at work (I'm at home now). I also had a death in the family, so I am leaving today and will be back next week. I will try all of your suggestions after I get back.