Return focus to a form

[clifftech]

Help please...

I'm using an Access form command button to open 2 spreadsheets. When the spreadsheets are open they hide the Access form that I need to immediately view for further processes. Is there a way to automatically set the focus back on the form once the spreadsheets are opened without having to click on the Access tab.

Here is the code that I'm trying without success:

Forms!frmName.Setfocus

Thanks in advance.

 

[PHV]

Have a look at the AppActivate instruction.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[clifftech]

PHV,

AppActivate worked. I never would have found it.

Thanks