I somehow feel that this is an extremely simple issue that I'm making far more complicated than it needs to be. I'm not a complete beginner with Access, but I'm also not an expert or much of a programmer.

I have a form on which I've created tabbed pages, each of which contains a subform so that the user can enter data in various fields across a number of different tables. All the forms seem to work correctly in terms of the fields and actually typing data in them, but I can't figure out how to create a button that, when pressed, will (1) update all the tables with the proper data, (2) clear the information from all the fields, and (3) return the user to the first of the tabbed pages. I basically want to recreate the "Save and New" functionality that shows up in many of the Access 2007 Microsoft-provided templates (such as Students), but while I've studied the various forms a great deal, I just can't seem to figure out how to do it.

Another (related) question: In one table, I have a primary key autonumber field that generates a unique identifier for each person to be entered the way described above. How can I pass that value to number fields in the other tables in my database when the information updates, as described in the paragraph above? I really want to make sure each record in those other tables is identified as coming from that specific person.

I have some other issues, too, but these will do to start with. Thanks for any help.

Actor,
You did so much tweaking in form properties and controls and made lot of controls invisible including your
PKs that it threw me off here for while, but it's done now.
Do your formating the way you want. I didn't play with that much.
See ATT

I also re-did all tables,removed spaces in names etc.

Edited by: jurotek on Sun Aug 5 14:46:42 EDT 2007.