Moving focus from 1 Form to another

[Guest]

Hello,

If I have an application that can have multiple Forms open at the same time
& even Report Viewing Windows, how can I automatically activate (or set the
Focus to) different Forms through VBA coding ?

I know there is ControlName.SetFocus but you cant do that with a Form. How
can that be done, something like FormName.SetFocus.

Any help would be greatly appreciated.

Thank you,
Jeff

 

[Nikos Yannacopoulos]

Jeff,

You are very close! Try:

Forms("FormName").SetFocus

HTH,
Nikos

 

[Ron Weiner]

Or this alternative syntax

Forms!FormName.SetFocus

Ron W