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
 

Ask a Question

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.

Ask a Question

Similar Threads

set focus to control on subform 0
Kill Focus on Subform 2
setting the focus to a nested subform 5
Focusing a subform 1
Backtabbing between SubForms on TabControls 2
Requery main form after subform update and not lose place in main form. 3
Sub Sub Form control set focus 2
take focus from subform 5

Top