Switching between active windows with VBA

[tgharris]

I'm not certain whether this question belongs in Access or in Office, but I have a project involving an Access form and a Word window. I know how to switch the focus to the Word window using the Activate method, but I want to be able to automatically return the focus to the Access form(make it the active window) without closing the Word window. Can anyone suggest something?<br>
<br>
<p>Tony Harris<br><a href=mailto:tgharris@techie.com>tgharris@techie.com</a><br><a href= > </a><br>

 

[DougP]

<br>
For Each myTask In Tasks<br>
If InStr(myTask.Name, &quot;Access&quot &gt; 0 Then<br>
myTask.Activate<br>
myTask.WindowState = wdWindowStateNormal<br>
End If<br>
Next myTask<br>
<br>
Of course Access must be the in the Systray <br>