subform tab control

[chad101]

How do you tab out of one subform and into another from the main form. I have 3 subforms and after a user is finished entering data into the main form the first subform sets focus. After data is entered into the subform it’s impossible to hit the “enter” or “tab” key to move onto the next subform.

 

[TedMartin]

This should do it


Private Sub LastField_Exit(Cancel As Integer)
Me.Next_subform.SetFocus
End Sub

 

[chad101]

thanks

Thanks, I'll give it a shot at work tonight

 

[chad101]

Seems like it would work but once i exit the last field inside my first subform I get this error.

run-time error '2465'

Microsoft Access can't find the field 'SubFrmtblCarbon' referred to in your expresion


EDIT: GOT IT! here is the code ran after last field is exited

Private Sub zone2Temp_Exit(Cancel As Integer)
Call Carbon

End Sub

Option Compare Database
Option Explicit

Public Sub Carbon()

Forms![FrmtblProcessFurnacePusher]![Child20].SetFocus

End Sub