Form won't activate

[Juergen Grieb]

Hi,

my app has one form A open constantly. If a button is clicked, another
form B opens. If the user now quits Acc97 I use the from_unload in
form B to cancel the event and close form B instead. So far so good.

Form A is still visible and data can be entered in the fields but it
seems form A is not "active". The window title is gray and the
form_activate is not called, neither when form B closes nor when you
click in form a after B closes. You have to switch to another
application then return to access to get form A to activate.

How do I activate form A in the event that form B closes?

Juergen

 

[pjscott]

Hi Juergen,

You might try using the following on form b in the click event:

docmd.close acform, "form b"

Hope this helps,

Paul

 

[Juergen Grieb]

Hi Paul,

You might try using the following on form b in the click event:

docmd.close acform, "form b"

Hope this helps,

Unfortunately, no.

I start an instance of Word in form B and let it run within B. Before
B is closed, I "free" Word, quit it and at this point the whole Access
application loses the focus.

Is there a possibility to give the focus back to Access? I guess that
would solve my problem.

Juergen