Unbound form/Add rows

N

nybaseball22

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
 
L

Linq Adams via AccessMonster.com

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.
 
Top