add row of textboxes dynamically

[gammaman]

I am fairly new to using forms in MS Access and was just wondering if the following concept can be done.




Let's say I have a table, each row containing 5 cells, each cell containing a TextBox

By default, I want only 1 row showing... but I want to have a Button that allows me to add an additional row every time it's clicked.



Is this something that can be done using VBA? Some other way?

[Skarvion]

Hi Gammaman,

Maybe you're talking about inserting a table to a form, which basically using an unbound object frame
Or do you want it to remain "form-like" using textboxes?

[gammaman]

It should be a form with text boxes. My current form has 5 text boxes which are all bound to the form. So, I am looking for a way to have multiple rows of textboxes. So say I have some button and add two additional rows of textboxes. When I fill out the form, it should insert 3 rows of data to the table.

[orange]

Perhaps you could tell us in plain English what your application is about, and why you think 3 rows of text boxes will insert 3 records. I'd just like to get more info.

Good luck.

[ssanfu]

Maybe change the form Default View from "Single Form" to "Continuous Forms".



BTW, "cells" and "rows" are Excel concepts. In Access, it is "controls" and "records".

[Missinglinq]

...My current form has 5 text boxes which are all bound to the form...

...When I fill out the form, it should insert 3 rows of data to the table...

If the first statement is correct...and all Controls are Bound...the second will occur automatically!

With a Continuous View Form (as suggested) or a Datasheet View Form, there is no need to have a Command Button to add New Records...one will always appear below the last entered Record.

Linq ;0)>