Using forms to input data

[Walt]

I have 3 tables and I create 3 forms to input data in each table. I added a
macro to each form so once you fill it out you click next and it takes you to
the next form. My question: Is there a way I can make sure no data is input
into the tables until all 3 forms have been completed?

Thanks

 

[Armen Stein]

I have 3 tables and I create 3 forms to input data in each table. I added a
macro to each form so once you fill it out you click next and it takes you to
the next form. My question: Is there a way I can make sure no data is input
into the tables until all 3 forms have been completed?

Thanks

Not easily. Access automatically commits the records into the
database the moment you navigate to another form or subform.

If each form just has one record, you can make them unbound and write
all their data manually after the third form.

Or if some have multiple records, you can create "work" tables of your
information, then at the very end write some code to transfer the data
into the main tables.

Or you can check all the data afterwards and delete it all out again
if it isn't complete.

Hope this gives you some ideas,

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

 

[Armen Stein]

Actually that's only partly true. Moving from main form to subform or from
subform to main form does, of course, save the record to the table, but
opening a second form, navigating to it and entering data, while leaving the
first form open, does not force a save in the original form. It's record will
still be dirty when return to it.

Yes, you're right. Thanks for the catch.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com