Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Tap order in mainform and subforms
- Thread starter Larshg
- Start date
Hi Larshg,
Something like this might help?:
The last control on your main form in it's on exit event:
Me.NameOfSubFormAsSeenByMainForm.SetFocus
You'll have to decide how you want to exit the subform and jump to the next 'cause if it's a continuous subform or a datasheet, you might upset your users if everytime they got to the last field on a row, it would jump to another subform. If it's a single form view, pretty much as above although you may have to first focus back to the mainform, then focus to your next subform:
Me.Parent.SetFocus
Forms!NameOfMainForm!NameOfOtherSubFormAsSeenByMainForm.SetFocus
Gord
ghubbell@total.net
Something like this might help?:
The last control on your main form in it's on exit event:
Me.NameOfSubFormAsSeenByMainForm.SetFocus
You'll have to decide how you want to exit the subform and jump to the next 'cause if it's a continuous subform or a datasheet, you might upset your users if everytime they got to the last field on a row, it would jump to another subform. If it's a single form view, pretty much as above although you may have to first focus back to the mainform, then focus to your next subform:
Me.Parent.SetFocus
Forms!NameOfMainForm!NameOfOtherSubFormAsSeenByMainForm.SetFocus
Gord
ghubbell@total.net
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question