If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Unbound form/Add rows
Hello. I have an unbound form. I want to know if there is a way I can
add rows to the form in the same way a bound form works. So, when I start a new record in the last open row, I want a new row to add to the end of the form, so I can always add a new record. I have the form unbound because I do not have the data enter into the table until after I finish working on all the information in the form. Thanks |
#2
|
|||
|
|||
Unbound form/Add rows
You can't have a new "record" on an unbound form because, in fact, you don't
have any "record," just a bunch of textboxes you've filled in! When people want to simulate this, the usual workaround is to have a form bound to a "holding" table, enter the records you want, edit them, etc, when ready append the data from the "holding" table to the permanent table and then delete the records from the "holding" table. -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200801/1 |
#3
|
|||
|
|||
Unbound form/Add rows
Sounds Good. Thank you.
|
Thread Tools | |
Display Modes | |
|
|