Setting focus to a field located on the subform

D

Drew

Are you using the "Forms" VB code?

Forms("NameOfForm").Forms.SetFocus
Forms("NameOfForm").Forms.NameOfControl.SetFocus

Drew

To move back to the main form you can use the
Me.Parent.NameOfCOntrol.SetFocus from inside the subform
to move the focus back to a control on the main form

PS - there is not intellisense for these so you have to
type out the entire control name and procedure
 
Top