Keeping Access in focus when using CreateObject

[tomatdeepwater]

I have an MS-Access application that manipulates several Office applications AND a 3rd party application via ActiveX using the "createobject" method. So far, I have had no problems controlling the other apps except the pesky problem of having the other app retaining the focus.

For example, after instantiating the 3rd party app, even though it is minimized while I manipulate it, my access form loses focus. I have tried the following:

Me.SetFocus
Me.Requery

I have looked at some API code, but I don't quite understand how to use it to bring my form back in focus.

Would anyone have an idea how to keep or restore the focus to my form from another non-Access window?

Thanks ahead of time for your help!

 

[PHV]

You may consider the AppActivate instruction.


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886