Forms with Pages

[Mindy]

I interviewed with a company that was using an Access Form and for each job
in my history I was entering the info on a new page of the form, also other
information was stored on different pages.

I am at a new job now, building a database that contains the following
tables: employee information, emergency info, and certifications. I would
like to build a form, so that when we get a new employee, I can enter all of
this info into all of the tables with one fell swoop.

Because it is so much info, I would like to have each table have their own
page.

Can anyone tell me how to do this? I'm familiar with building forms, but
now also I am doing it on Access 2007. I've just never come across how to
attach another page.

 

[Golfinray]

If you are saying you would like to have one table per page, that is not the
right way to do it. Have one mainform and two subforms. The mainform would
contain employee information and the subforms would be linked to the mainform
(let the subform wizard do that for you) and one subform would show emergency
info, the other certifications.

 

[Mindy]

Size-wise, there is too much info to be organized on one screen.

Logically, I would break it down by table, but I don't have to do that...

Can I create pages with the subforms? I've never used a subform.

 

[Golfinray]

When you go into design view on your mainform there is an icon for subforms.
The subform wizard will walk you through it. The other option (look at the
help files on tabbed pages) is put each form on a tab. That might be easier
you a newer user than trying to build subforms. You just put tabs (like if
you had tabs on a book to find your place) on one form (as many as you need)
then you put one form on each tab. You can scroll through each tab until you
find the info you need.