Key down event for controlling flow

[yoshe]

Hello, I am trying to use key down (If KeyCode=vbKeyTab) to control the flow from one control to another on a form with subforms on a tab control. I initially used the LostFocus event, but this drives people crazy if they use the mouse to navigate rather than tab (they click into a field but the lost focus sends them somewhere else). So I only want to set the focus if tab is pressed. Here is the problem: the focus is always going to the next field in the tab order, and skipping the one where i want it to go. What could be the reason for this? I've tried on 3 different keyboards and same result.

 

[Remou]

Is this what you want?

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
Select Case KeyCode
    Case 38
        KeyCode = 0
        If Not Me.Recordset.BOF Then
            Me.Recordset.MovePrevious
        End If
    Case 40
        KeyCode = 0
        If Not Me.Recordset.EOF Then
            Me.Recordset.MoveNext
        End If
End Select
End Sub

 

[yoshe]

Remou, I'm not really sure what this is supposed to do. Tab is coming up as KeyCode=9 for me. I tried substituting that in the cases, but that basically prevents the cursor from moving. Also, I want to move between recordsets, ie from the end of one subform to the beginning of the next, or some other field on the parent form.

 

[TheAceMan1]

How are ya yoshe . . .

Have you tried rearranging the tab order?

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[yoshe]

TheAceMan1, yes, it works as desired if I switch the tab order and code it to go to one control previous in the order. Kind of ugly though and throws off the flow for people who click into a field. A google search brought up this:

http://support.microsoft.com/kb/327821

Not sure if it applies to me, since it does seem to capturing the tab, but i'll play around with it...