Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    105
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Tab order with a subform (2000)

    I've created a form with a subform halfway through it. If I set the form in the same place in the tab order as on the form, it will tab into the subform ok but will not tab out of the subform to the remaining fields. Is there a way to make this work?

    - Eric

  2. #2
    Lounger
    Join Date
    Apr 2001
    Location
    Khon Kaen, Thailand
    Posts
    43
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tab order with a subform (2000)

    Hi,

    When you are in a subform and want to get out to a next text box on the main form, just hit <font color=red>Ctrl + Tab</font color=red>

    Tim K.

  3. #3
    2 Star Lounger
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    105
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tab order with a subform (2000)

    Thanks. I'm wondering if there is any way to do it without the Ctrl + Tab so that the fields in the subform act just like part of the parent form.

    -Eric

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Tab order with a subform (2000)

    If you want to make the tab out of the subform invisible to your users, add another textbox to your subform. Make it unbound and locked with a zero width and a backcolor the same as your subform's background. Make it the last control in the tab order of your subform. Then, in the OnEnter event of the control do something like this:

    <pre>Private Sub txtReturn_Enter()
    Me!fsbOrders.SetFocus
    Me!fsbOrders.Form![txtOrderDate].SetFocus
    End Sub</pre>


    In this case, txtReturn is the name of the textbox, fsbOrders is the name of the subform control, and txtOrderDate is the name of the textbox on the subform that I want to set focus to. Otherwise, your user will have to tab twice to get to the first control in the subform.

    Then put a similar unbound textbox on your subform (I'm assuming this is *not* a continuous subform) but set the focus to the Parent form and then its next control.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •