Unbound form/Add rows

[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

 

[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

 

[nybaseball22]

Sounds Good. Thank you.