Tab Order through Subforms (1 Viewer)

jharding08

Member
Local time
Yesterday, 21:52
Joined
Feb 16, 2021
Messages
52
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

I’m here to help
Staff member
Local time
Yesterday, 21:52
Joined
Oct 29, 2018
Messages
18,962
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

Immoderate Moderator
Staff member
Local time
Yesterday, 23:52
Joined
Feb 28, 2001
Messages
22,780
Normally, you would use the form's .Cycle property.


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

Member
Local time
Yesterday, 21:52
Joined
Feb 16, 2021
Messages
52
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

I’m here to help
Staff member
Local time
Yesterday, 21:52
Joined
Oct 29, 2018
Messages
18,962
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.
 

Users who are viewing this thread

Top Bottom