Form Navigation

[PADFOR]

How do I navigate from the sub-form back to the main forms using keyboard. When the focus is in a sub-form, it remains there.

How do I capture a key (TAB) (keyboard event) when I am leaving the sub-form to put me back into the main form? Can this be done using Macros?

Cheers

PADFOR

 

[ghubbell]

Hi Padfor,
Your subform properties "Events" tab: towards the bottom find "Key Preview" and turn it on (Yes).

In the Key Down event (event procedure) then "..." to visual basic, something like this:

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
Dim ctl As Control
Set ctl = Me.ActiveControl
If Me.ActiveControl.Name = "NameOfYourFieldHere" Then
If KeyCode = vbKeyTab Then
Me.Parent.SetFocus
Me.Parent.NameOfSomeFieldOnYourMainForm.SetFocus
End If
End If
End Sub

Will do. Gord
ghubbell@total.net