Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Seattle, Washington, USA
    Posts
    179
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Tab order not correct (Access 2002, SR 1)

    I have a form with a Lookup Combo box and a bound subform that is in a datasheet view. The datasheet view has two columns: One is "combobox view" with list of classes and second column is checkbox. When I press tab key from the lookup combo box, it goes to Course field in the datasheet view and then when I tab, it goes to Ride checkbox and so on.

    My problem here is that if I am done with entering courses, I could tab twice (to move from Courses, to checkbox and then out of datasheet view into Lookup combo box). However, when I enter a different person, then tab, it doesn't go to the Course field, rather, it goes directly to the Ride checkbox! I checked the tab order and it shows proper order. The only work around I have is to control+tab out of the datasheet twice because it "jumps" to top of the datasheet then "jumps" to the lookup combobox. This is annoying, so I used a bit of code to check if the field is null then automatically go to the Lookup Combobox. But then when I change name of person and tab into the datasheet, it goes straight to the checkbox! <img src=/S/help.gif border=0 alt=help width=23 height=15>

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tab order not correct (Access 2002, SR 1)

    In the On Enter of the subform control , set the focus to combobox.
    Something like :
    <pre>Private Sub Contact_subform_Enter()
    Me.Contact_subform.Form.cmbContactName.SetFocus
    End Sub</pre>

    Francois

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Seattle, Washington, USA
    Posts
    179
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tab order not correct (Access 2002, SR 1)

    Cripes. I had tried something similiar to this but I had tried to run it UponExit at the ComboBox and kept on getting error about cannot find subform. I didn't think about running it ENTERING the subform! Grin.

    Thanks.

Posting Permissions

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