Modal property help

[Guest]

When my Access 2000 db opens, I have a form (a ShutDown form) that
automatically opens and set visible to false. It's Popup property set to
true. There is a Timer Event code on this form that will make it visible.
My problem is that most of my other forms have the Modal property set to
true. When that ShutDown form gets activated, it becomes visible, however I
can't click on any of the controls on that form. Is there a way I can get
the ShutDown form gain focus when it becomes visible on top of a modal form?

 

[Alex White MCDBA MCSE]

The only way I can think of is to close the hidden form in code and open it
again Modal, it would then be the top form.

 

[Guest]

Cool. I didn't think I could that, ie. tell a form to close itself and
reopen right after. Plus, my Timer event coding still works! How does that
work?

I added just 2 lines:
DoCmd.Close
DoCmd.OpenForm "frmAppShutDownWarn"

Thanks for your help!

 

[Alex White MCDBA MCSE]

The reason the timer still works is (I'm guessing here), the time between
closing and reopening is so short, the timer must be restarting though, the
reason the form can close itself and reopen is the sub proc has to complete
even though it has been asked to close, to do this from another form

docmd.close acform, frmAppShutDownWarn",acsaveyes
docmd.openform "frmAppShutDownWarn"

along as it works that's good...