Tab Order through Subforms

[jharding08]

I have a main form that has 5 subforms with text controls and in those subforms , there are subforms with text boxes.

The main form has 8 text boxes that have tab order 0-7, then the first subfrm1 has two text boxes then a subform(1.1) with three textboxes

I need to go from:
MainForm.textbox7 THEN

Subfrm1.textbox0 -> subfrm1.textbox1 THEN​

Subfrm(1.1).textbox0-> Subfrm(1.1).textbox1 -> Subfrm(1.1).textbox2 THEN​

Subfrm (1.2).textbox0-> Subfrm(1.2).textbox1 -> Subfrm(1.2).textbox2 THEN​

Subfrm1.textbox2 -> subfrm1.textbox3->subfrm1.textbox4->subfrm1.textbox5 THEN​

Subfrm2.textbox0->Subfrm2.textbox1 -> subfrm2.textbox2 THEN​

Subfrm3.textbox0 -> subfrm3.textbox1 THEN​

Subfrm(3.1).textbox0-> Subfrm(3.1).textbox1 -> Subfrm(3.1).textbox2 ...ETC...​

​

Do I need to use LostFocus event in last tab stop control to assign focus to next control?

 

[theDBguy]

Do I need to use LostFocus event in last tab stop control to assign focus to next control?

I believe so. Give it a try and let us know how it goes.

 

[The_Doc_Man]

Normally, you would use the form's .Cycle property.

Form.Cycle property (Access)

Office VBA reference topic

docs.microsoft.com

However, There is no cycle setting for "go back to previous level" - which appears to be what you need. I believe that your case will require a more complex selection than the standard offerings and therefore, to your ending question, I'm thinking "Yes."

 

[jharding08]

Using LostFocus() or Exit() seems to work for forward tab order. I would need to add the programming if I wanted to do reverse tab order, but I've seen the code that works

 

[theDBguy]

Using LostFocus() or Exit() seems to work for forward tab order. I would need to add the programming if I wanted to do reverse tab order, but I've seen the code that works

Hi. Glad to hear you're making good progress. Good luck with your project.