Tabbed pages are really made for this type of thing. Here's a short little
step-by-step for setting them up:
First thing to remember is that the Tabbed Pages are all part of a single
form; think of it as a really long form turned on its side, whcih makes it
easier to navigate between. Because it is all one form, all referencing to
any control on it is done in the same manner as if they were all on one
single screen. Create a form in Design View. Goto the toolbox and click on
the Tabbed Control icon; it actually looks like several manila file folders.
Place it on your form and adjust the size to your liking. If you need more
than the two tabbed pages it initially gives you, click on the tabbed control
to select it. Goto Insert and click on Tabbed Control Page and another tabbed
page will be added. Do this as many times as necessary.
This is the really important part: when you go to add a control to a tabbed
page, you must first click to select one of the pages, then add the control.
Otherwise, the control will be added to the form itself, and will show thru
on all tabbed pages!
Once you have the form's Control Source (your table or a query) set up, you
simple add controls as you normally would, heeding the above paragraph.
The tabbed pages, of course, have their own tabs at the top for moving
between pages, or you can place a button on each to move to the next page.
Remember, per the instructions above, to select the page, then add your
command button to the page. This simple code will move you to Page2 in this
example. You'd need to change your button names/page names to reflect your
actual object names.
Private Sub GoToPage2_Click()
Page2.SetFocus
End Sub
Good luck!
