Active Event

[PeterM]

I have three forms that I'm dealing with, FormA is a menu form, FormB is a
form called from FormA and FormC is a popup for FormA. I have hyperlinks on
FormA calling FormB. When FormB closes I have a Form Activate event to check
a condition and then open FormC with a Docmd.OpenForm statement. The problem
that I'm having is because FormA uses a hyperlink item to call FormB, once
FormB is closed and FormA is in focus the Acitvate event is not firing,
therefore FormC is not called. When I changed the hyperlink calls in FormA
to Docmd.OpenForm the activate in FormA fires after FormB closes. How can I
force an Activate or is there another way?

Thanks for your help!

 

[Arvin Meyer [MVP]]

I have three forms that I'm dealing with, FormA is a menu form, FormB is a
form called from FormA and FormC is a popup for FormA. I have hyperlinks
on
FormA calling FormB. When FormB closes I have a Form Activate event to
check
a condition and then open FormC with a Docmd.OpenForm statement. The
problem
that I'm having is because FormA uses a hyperlink item to call FormB, once
FormB is closed and FormA is in focus the Acitvate event is not firing,
therefore FormC is not called. When I changed the hyperlink calls in
FormA
to Docmd.OpenForm the activate in FormA fires after FormB closes. How can
I
force an Activate or is there another way?

Hyperlinks are not code and are an outside method of opening, so specific
code may not run. Keep using DoCmd. If you like the Hyperlink look,
underline and change the color of a label to blue. You can even use an API
in the MouseMove event to change the cursor to a pointed hand,

 

[Jeanette Cunningham]

In addition to Arvin's note about the cursor,
A2007 gives the option of using a pointed hand on buttons, without needing
to write any code.
Look on the other tab of the properties dialog.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia