Detecting when Tab is pressed

[bobh]

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.

[Salad]

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

[bobh]

On Jan 10, 11:43*am, Salad <[e-mail]:

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 Bombhttp://www.youtube.com/watch?v=nETVIeygqjY

That worked....... Thanks :)