Sub Form Tab Order Cycles

[Navyguy]

Hello To All

I have searched this area for a similar problem that I am having and found a similar post. Link below.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=34648&highlight=tab+order

What I wouls like to know if there is a better way of doing this? I can't see a user using the Tab key and then trying to switch to Control Tab to jump out of a subform and into the next subform.

Maybe I am just searching under the wrong terms. I searched using "Tab Order".

Navyguy

 

[Navyguy]

Just wondering if anybody had any ideas on this.

Looking at only using the tab button to move from field on main form to fields in subform and then to fields on another subform within the same main form.

Any sugestions would be greatful!!

Thanks muchly

Navyguy

 

[ehdoh]

I program an afterupdate event to setfocus to the next subform and then GotoControl to move the user to the first control on the subform. For example:

Forms!MH_Form.SetFocus
DoCmd.GoToControl "combo5"

Good Luck!

 

[Navyguy]

Thanks...

I will give that a try.