set focus on specific control on a form after closing report

[irade92]

How to set focus on a specific control in a form after closing a report or another form...What to write in Event ..on Close

 

[vbaInet]

In the help files, i.e. hit the F1 key on your keyboard, search for the SetFocus event.

 

[missinglinq]

Actually, you can use the Form_Activate event of the Form that you're returning to to set the Focus

Private Sub Form_Activate()
 YourFieldName.SetFocus
End Sub

assuming that you don't mind this Control having Focus when the Form itself initially opens, as well as when you 'return' to it.

Linq ;0)>