I have created a hidden form that opens when my Access application
opens. I'm using it to capture the application close event. I want
this form to be closed before any other open forms when the user
closes the application. Is there a way to do this? Does Access close
forms in alphabetical order? Or is it "FIFO", so the first opened form
will be the first closed form?

Thanks in advance for your help,

Erika

misseill wrote:
> I have created a hidden form that opens when my Access application
> opens. I'm using it to capture the application close event. I want
> this form to be closed before any other open forms when the user
> closes the application. Is there a way to do this? Does Access close
> forms in alphabetical order? Or is it "FIFO", so the first opened form
> will be the first closed form?
>
> Thanks in advance for your help,
>
> Erika

First form opened will be the LAST form closed. That is normally what you
want for detecting application close.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com