Unbound Form Events

[Stu]

I have an unbound form (Access2003) used as a main menu to bring up other
forms and reports. The main menu form is not closed when a second form or
report is called. I'm looking for an event that is triggered when I return
back to the main menu from another form.

I've put MsgBox's in the Activiate, GotFocus, Click, MouseUP/Down and
SelectionChange events but none are triggered when I click on the main menu
form. What FORM event is triggered upon closing a second form and the user
returns and interacts with the main menu?

 

[Ken Snell [MVP]]

The first form's Activate event should fire in that scenario. Or you could
use the second form's Close event to run the code you want to run.

 

[Stu]

As stated I put a MsgBox statement in the On Activate event code and the
Msgbox did not pop-up. From your comment it sounds like the Activate event
should fire in this scenario. What about the GetFocus or Click events?
Should they also fire when the user clicks the first form after returning
from the second?

 

[Stu]

Some further info...the help files state that the click/mouseup/mousedown
events are triggered when a click is made in a "blank area of the form". I
CAN get these events to fire but only when the click is at the bottom of the
form, i.e., after the point of the last form field/button is placed and not
any blank area above the last form field/button. That doesn't work for me, I
was hoping that clicking any place on the form would fire these events.

Still looking for an event that fires when returning from the second form.

The second form close event isn't good as there are many forms that would
need the same code.

 

[Ken Snell [MVP]]

Is the first form being opened modally (e.g., a Dialog mode)?

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

 

[Stu]

No it is not: Modal = No
I think it's time to close this question since I implemented a couple of
form object On Click events as workarounds.
Thanks for your response(s). Much appreciated.

 

[Ken Snell [MVP]]

One other possibility.. if you are opening the second form as a Popup form,
then the first form's Activate event will not fire when you return to it by
closing the second form.

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/