Moving focus from 1 Form to another

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeff - 31 Mar 2005 13:35 GMT

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

Reply to this Message

Nikos Yannacopoulos - 31 Mar 2005 13:41 GMT

Jeff,

You are very close! Try:

Forms("FormName").SetFocus

HTH,
Nikos

> Hello,
>
[quoted text clipped - 9 lines]
> Thank you,
> Jeff

Reply to this Message

Ron Weiner - 31 Mar 2005 13:52 GMT

Or this alternative syntax

Forms!FormName.SetFocus

Ron W

> Jeff,
>
[quoted text clipped - 18 lines]
> > Thank you,
> > Jeff

Reply to this Message