Sep 23 2004, 12:06 PM
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.
Sep 23 2004, 12:28 PM
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.
Sep 23 2004, 01:22 PM
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?
Sep 23 2004, 02:29 PM
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.
Sep 30 2004, 12:43 PM
Thank you for pointing me in the right direction.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here