Detecting when Tab is pressed

Hi All,
In AccessXP I have a form, it has a form header, detail and footer
sections. When done entering text in a txtbox(bxReqst) in the footer
the user wants to press the Tab key and have the focus move to a
control called bxQues in the Detail section.
From the control in the footer how do I detect when a Tab key is
pressed and set the focus to the control(bxQues) in the detail
section?
thanks
bobh.
BobH [ Do, 10 Januar 2008 17:18 ] [ ID #1904581 ]

Re: Detecting when Tab is pressed

bobh wrote:
> Hi All,
> In AccessXP I have a form, it has a form header, detail and footer
> sections. When done entering text in a txtbox(bxReqst) in the footer
> the user wants to press the Tab key and have the focus move to a
> control called bxQues in the Detail section.
> From the control in the footer how do I detect when a Tab key is
> pressed and set the focus to the control(bxQues) in the detail
> section?
> thanks
> bobh.

Here's an example using KeyDown for a textbox
Private Sub Text8_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = 9 Then Me.Text4.SetFocus
End Sub

Da Bomb
http://www.youtube.com/watch?v=nETVIeygqjY
Salad [ Do, 10 Januar 2008 17:43 ] [ ID #1904583 ]

Re: Detecting when Tab is pressed

On Jan 10, 11:43=A0am, Salad <o... [at] vinegar.com> wrote:
> bobh wrote:
> > Hi All,
> > In AccessXP I have a form, it has a form header, detail and footer
> > sections. When done entering text in a txtbox(bxReqst) in the footer
> > the user wants to press the Tab key and have the focus move to a
> > control called bxQues in the Detail section.
> > From the control in the footer how do I detect when a Tab key is
> > pressed and set the focus to the control(bxQues) in the detail
> > section?
> > thanks
> > bobh.
>
> Here's an example using KeyDown for a textbox
> Private Sub Text8_KeyDown(KeyCode As Integer, Shift As Integer)
> =A0 =A0 =A0If KeyCode =3D 9 Then Me.Text4.SetFocus
> End Sub
>
> Da Bombhttp://www.youtube.com/watch?v=3DnETVIeygqjY

That worked....... Thanks :)
BobH [ Do, 10 Januar 2008 18:50 ] [ ID #1904587 ]
Datenbanken » comp.databases.ms-access » Detecting when Tab is pressed

Vorheriges Thema: form not displaying accurate sums.
Nächstes Thema: Record Copy No-Brainer