I've created a form with a subform in it. Is there a way to set up the Tab Order so the tab will go to the next tab stop in the form after the subform? I've tried messing with the tab stop property and the cycle property, but that doesn't seem to change tab order b/c once you get within the subform, the tab will get stuck within that subform. Ideas?
Kevin Robertson
@Reply 3 years ago
In the Lost Focus event of the last field on your subform set the focus to the field on the parent form.
Kent JamisonOP
@Reply 3 years ago
What is the code for that?
Kevin Robertson
@Reply 3 years ago
Sorry. I meant KeyDown event.
The code below will set the focus from the Notes field on my subform to the FirstName field on the parent form when the TAB key is pressed..
Private Sub Notes_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = 9 Then '9 = TAB
Parent!FirstName.SetFocus
End If
End Sub
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 8.
