Moving between pages of tabs in a form

  • Thread starter Thread starter forest8
  • Start date Start date
F

forest8

Hi there

I have created a form which has 5 tab pages.

I want to create an event in which I can preview the results of the five
tabs by first viewing the first page, then the second, third, and so on.

I'm not sure how to do this.

Essentially, I want to be able to see whether all 5 pages have been filled
correctly.

Thank you in advance.
 
Hi there

I have created a form which has 5 tab pages.

I want to create an event in which I can preview the results of the five
tabs by first viewing the first page, then the second, third, and so on.

I'm not sure how to do this.

Essentially, I want to be able to see whether all 5 pages have been filled
correctly.

Thank you in advance.
Click to expand...

One thing to consider: the data is NOT stored on your form or in your tabs.
It's in your table. The form (tabs or no) is just a window on the data in the
table.

That said... do you have SO MANY fields that you need five tabs to show them??
If so, your table is almost certainly incorrectly designed. Thirty fields is a
*VERY* wide table.

If you have a different Subform on each tab, that's a bit less
anxiety-provoking, but be aware that the records will already have been saved
to disk (as soon as you move the focus from form to subform or vice versa).

I would expect that the user would want to do *something* - click a button,
for example - when they have finished reviewing a page. If so... why not just
click the next tab? What user interaction were you considering?
 
You have to tweak this to tell it to stop... it loops all the way
through the tabs continuously. Happy tweaking.

Option Compare Database
Private iTab As Integer

Private Sub Form_Timer()
iTab = iTab + 1
Dim tabNo As Integer

tabNo = iTab Mod Me.TabCtl0.Pages.Count

Me.TabCtl0.Pages(tabNo).SetFocus

End Sub
 
Hi there

I have created a form which has 5 tab pages.

I want to create an event in which I can preview the results of the five
tabs by first viewing the first page, then the second, third, and so on.

I'm not sure how to do this.

Essentially, I want to be able to see whether all 5 pages have been filled
correctly.

Thank you in advance.
Click to expand...

Why do you want to manually preview all the data? If it were my job,
I would write a validation routine that returned a boolean which
toggled a red/green light or something stupid. If I don't have to
look at the data, I won't. I'll let the computer do it for me.
 
I want to set up 1 single click so that it cycles through the oages,
Click to expand...

I'd be inclined to put a "next page" button on each page, in the same place,
so the user can hold the mouse at one position and click once for each page. I
agree that just having the pages automatically scroll by would be too slow, or
too fast, or BOTH.
 
Thank you to everyone who've responded to my question. As a Novice Access
user, it is good to for me hear more expert advace.
 
Back
Top