Help sought creating Forms in Access 2002

I am trying to create very simple database for a Modelling Agency. All the data will get entered to one table namely tblPersonaldetails. Following are the fields:

ID

First Name

Last Name

Sex

Category

Address1

Address2

Suburb

City

Phone

Fax

Mobile

Email

Age

Height

Ethnicity

Hair

Eyes

Chest

Waist

Hips

Collar

Suit

Shoes

Modelling

Photographic

Dance

TV

Sport



I am using 3 forms to enter data in this table. frmPersonaldetails takes data from ID - Email. frmVitalstat takes data from Age - Shoes. frmExperience takes data from Modelling - Sport.

Now I have 3 queries to this community: 1) How to ensure that the data entering in 3 different forms will get populated as one record in tblPersonaldetails?



2) Is it possible to have these 3 forms as tabs so that it is quite easy go from one form to another while entering the data? I do not want to use the Switch board where one needs to exit from one form to go back to the switchboard before accessing the other form. Please take a look at this site: http://www.amazon.com/exec/obidos/subst/home/home.html/102-0669297-0801733



You can see in the above link how Welcome, Your Store, Books, Apparel & Accessories, Electronics etc. has formed tabs at the top of the website. I want my 3 forms to have similar sort of tabs with in my access application.





3) I have seen previously that it is possible to gave 2 access files where one is the application and other one is the data file. The benefit of this mechanism is that it's easier to modify the Application while not disturbing the Data file at all (where the tblPersonaldetails lies outside the Application file). How can I achieve that?



Can someone answer my queries, please? Many thanks in advance.



Cheers

Dear Hanna

the easiest way will be for you to use a 3 tab control on a form bound to your table.
You can do it in a few simple steps
1) create the table and define all the fields
2) create an empty form
3) bind the empty form to the table using property>data>datasource
4) drag the multitab control from the toolbox
5) add another tab and set the captions of each page
6) drag the single fields from the field list to the pages

Appreciated your help Paolo. It's sorted now.

Many thanks