access thread: Sub form will not Tab to next Sub Form
Message #1 by "Christopher Oberheim" <choberheim@l...> on Thu, 12 Jul 2001 00:40:03
|
|
I am using multiple sub forms and while they are in the correct Tab Order
I am unable to tab from the last cell in say sub form 1 into the first
cell of sub form 2. Any Ideas?
Thanks in advance for your help.
Chris
Message #2 by erezmor@n... on Thu, 12 Jul 2001 06:33:45 -0400
|
|
"Access" <access@p...> wrote:
>
> I am using multiple sub forms and while they are in the correct Tab Order
> I am unable to tab from the last cell in say sub form 1 into the first
> cell of sub form 2. Any Ideas?
>
> Thanks in advance for your help.
> Chris
> ---
hello chris
one thing i do is just write a short code for the "OnExit" or
"OnLostFocus" events of the last control in the 1st subform that
"setfocus" to the first control of the next subform.
good luck!
erez.
Message #3 by Christer Hantveit <CH@t...> on Thu, 12 Jul 2001 13:56:24 +0200
|
|
I theink u also can use the combination ctrl+tab
C
-----Original Message-----
From: Christopher Oberheim [SMTP:choberheim@l...]
Sent: 12. juli 2001 02:40
To: Access
Subject: [access] Sub form will not Tab to next Sub Form
I am using multiple sub forms and while they are in the correct Tab Order
I am unable to tab from the last cell in say sub form 1 into the first
cell of sub form 2. Any Ideas?
Thanks in advance for your help.
Chris
Message #4 by "Christopher Oberheim" <choberheim@l...> on Thu, 12 Jul 2001 13:46:34
|
|
I have a limited understanding of VBA any ides on how to write OnLostFocus
in one subform to focus on a control in another subform?
> "Access" <access@p...> wrote:
> >
> > I am using multiple sub forms and while they are in the correct Tab
Order
> > I am unable to tab from the last cell in say sub form 1 into the first
> > cell of sub form 2. Any Ideas?
> >
> > Thanks in advance for your help.
> > Chris
> > ---
> hello chris
> one thing i do is just write a short code for the "OnExit" or
> "OnLostFocus" events of the last control in the 1st subform that
> "setfocus" to the first control of the next subform.
> good luck!
> erez.
>
Message #5 by "Chris Kryshtalowych" <ckryshtalowych@u...> on Fri, 13 Jul 2001 15:01:49 -0400
|
|
Hi-dee ho, Chris!
Enter this code into the "On Lost Focus" event procedure of the last control on
SubForm1:
Private Sub LastCtrlSfrm1_LostFocus()
me![SubForm2]![FirstCtrlSfrm2].setfocus
End Sub
Where:
"SubForm1" is the name of your first subform
"LastCtrlSfrm1" is the name of the LAST control on SubForm1
"SubForm2" is the name of your second subform
"FirstCtrlSfrm2" is the name of the FIRST control on SubForm2
Alternately, I believe you can use <ctrl-tab> to jump between subforms.
Hope that helps!
Chris "Now where did I put MY focus?" Kryshtalowych
Systems Specialist
University Healthcare System
Augusta, Georgia
{snip}
>Subject: Re: Sub form will not Tab to next Sub Form
>From: "Christopher Oberheim" <choberheim@l...>
>Date: Thu, 12 Jul 2001 13:46:34
>I have a limited understanding of VBA any ides on how to write OnLostFocus
>in one subform to focus on a control in another subform?
>
>> "Access" <access@p...> wrote:
>> >
>> > I am using multiple sub forms and while they are in the correct
>>Tab Order
>> > I am unable to tab from the last cell in say sub form 1 into the first
>> > cell of sub form 2. Any Ideas?
>> >
>> > Thanks in advance for your help.
>> > Chris
>> > ---
>> hello chris
>> one thing i do is just write a short code for the "OnExit" or
>> "OnLostFocus" events of the last control in the 1st subform that
>> "setfocus" to the first control of the next subform.
>> good luck!
>> erez.
{/snip}
|
View Cart
