Tab Order with SubForms - Microsoft Access Beginner 8


	Back to Access Beginner 8 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Tab Order with SubForms

Kent Jamison

3 years ago

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 Jamison OP @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`

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Beginner 8.

Next Unseen

New Feature: Comment Live View