By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,166 Members | 1,130 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,166 IT Pros & Developers. It's quick & easy.

dumbest 2003 question of all time

P: n/a
I spent a lot of time in access 97 simply because that is the way we
have always done it.
So when we changed over to 2003 (last week LOL) I ran into a lot of
new things.

but this one I am not too sure about.
when you have multi tabs on a tabctl and you are go to a visible tab,
in this case there are 3 tied to 3 forms that are tied to the same
table.

main table is eligibility......idnum
secondary table that the 3 forms are tied to is changes....with a
field called link so that it can use idnum to link in a 1 to 1
relationship.

What is the best way when you reach the bottom of page1 to setfocus to
the top of page2.

the reason I ask is I have always done this on a hidden field.

==============================
Public Function NextPage(tabctl As TabControl, min As Integer, max As
Integer)
If max = 0 Then max = tabctl.Pages.count - 1
Dim counter As Integer
counter = 0
Do
counter = counter + 1
If (tabctl.Value + counter) (max) Then
counter = min - tabctl.Value
End If
Loop Until (tabctl.Pages(tabctl.Value + counter).Visible)
tabctl.Pages(tabctl.Value + counter).SetFocus
End Function
===============================

my way of thinking (that is probably wrong) is that if you are sitting
on the last field on the form and hit shift tab or something then if
you don't go to this hidden field you won't be taken to the next page
when you didn't want to go...since some of the data people use mouse,
keyboard and whatnot to do things on the form.

so I the last field if you hit tab, you would hit the hidden field and
go to the next page..
I know that I could do something like SendKeys ("^{TAB}") on the last
field but again only a mouse would allow it.

what is the best way to do this, cycle thru the 3 "visible" forms.

thank you for your ideas
Jerry

Jul 17 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.