Tabs between subforms

F

Fay Yocum

I need to know how to tab between two subforms on the main control.

Thank you.

Fay
 
F

Fay Yocum

Thanks John. But I want the tabbing to happen automatically for users who
aren't aware that there are multiple subforms on the form. So what do I need
to do VBA wise to make this happen? Fay
 
F

Fay Yocum

Got it!!!!!

Private Sub txtEffectiveDate_Exit(Cancel As Integer)
Forms.frmLearners.subfrmTelephone.SetFocus
Forms.frmLearners.subfrmTelephone!txtTelephoneType.SetFocus
End Sub

Thanks. Fay
 
J

John Vinson

Got it!!!!!

Private Sub txtEffectiveDate_Exit(Cancel As Integer)
Forms.frmLearners.subfrmTelephone.SetFocus
Forms.frmLearners.subfrmTelephone!txtTelephoneType.SetFocus
End Sub

Thanks. Fay
Click to expand...

It's possibly a bit safer to put an additional small, transparent,
unbound control last in the tab order, and use its GotFocus event as
above. If you have a user who prefers to mouseclick they might click
this textbox first, and then click another textbox on the same subform
- and be disconcerted at the result!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top