Tab order not correct (Access 2002, SR 1)

Topic

New Reply

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!

Reply | Quote

Replies

In the On Enter of the subform control , set the focus to combobox.
Something like :

Private Sub Contact_subform_Enter()
Me.Contact_subform.Form.cmbContactName.SetFocus
End Sub

Reply | Quote

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.

Reply | Quote