Button linking to next page

  • Thread starter Thread starter weircolin
  • Start date Start date
W

weircolin

Hi there

I am creating a kids questionaire and I am looking for a bit of
information please.

Is it possible to have it so there is only one or two questions on a
page and then there be a button that links to another form/page with
the next questions and still cave them all to the same table?

If so, how do I instruct the button to do this?
 
in a subform:
You can turn off the scroll bars and make a very long form,(several screens
tall) and then make buttons that use a:

doCmd.gotocontrol "page2Question1"
to "scroll" to the next page

that will look like multiple pages to the user
(and you still get scroll bars in Design view)

hth
 
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!

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
 
Back
Top