Tab from From Header to Detail Section?

[James T.]

Access 2000

Can you make a tab go from a forms Header section to the
Detail section? I am trying to go from a combo box after
the record is pulled up to the first box in the forms main
section.

Thanks for any help.

James

 

[Wayne Morgan]

Try a SetFocus statement to set the focus to the control you wish in the
LostFocus or Exit event of the control on the header that you are tabbing
out of.

 

[James T.]

Wayne,

I tried this on the Lost Focus of the combo box:

Private Sub Combo23_LostFocus()
Me.FileNumber.SetFocus
End Sub

(FileNumber is the first box on the form.)

And it didn't work. It also seemed to interfere with the
combo box lookup code as it brought up the debug. When I
took out the Lost Focus code, it went back to normal.

James

 

[Wayne Morgan]

Ok, possibly use the Key Down event to check for the Tab key and move the
focus when Tab is pressed.

If KeyCode = vbKeyTab Then Me.FileNumber.SetFocus