I was hoping that someone out there might know how to create a rows of textboxes that match the first row of textboxes. What I am trying to do is ask the user how many rows they are going to need, when the number is entered and the the command button is click, I want the following form to open with the number of rows identical to the first row, that the user specified. Is this possible?

Thank you in advance for any help you might give.

Do you just need empty boxes? Form or report? Do these entries in these boxes need to be saved ? Give me some basics on what this is for and what its behavior will be and I'll see if I've got any ideas.

Ken

The text boxes will need to be empty for data entry in a form that will be used for calculations. They will not need to be saved.

The data in the text boxes will be manipulated with basic equations and then dumped into a report.

Do you need more info?

Thank you

I think an unbound recordset would work for you here. Or maybe a temp table. I know unbound recordsets are possible but I've never got around to using one and don't have any examples. A temp table would just be the source of the continuous form, you can do the calcs in a query if needed. The user wouldn't type in a value for number of rows they would just add as needed. I think that would be the easiest as this table could then be used for the report as well. You would need to make sure to compact/repair on a somewhat regular basis to clear up the bloat of this temp table.

HTH
Ken

Thank you for pointing me in the right direction.