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
Private Sub txtEffectiveDate_Exit(Cancel As Integer)
Forms.frmLearners.subfrmTelephone.SetFocus
Forms.frmLearners.subfrmTelephone!txtTelephoneType.SetFocus
End Sub
Private Sub txtEffectiveDate_Exit(Cancel As Integer)
Forms.frmLearners.subfrmTelephone.SetFocus
Forms.frmLearners.subfrmTelephone!txtTelephoneType.SetFocus
End Sub
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!
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
