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.


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.

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question