Close Form Faster

A

alex

Hi,

Does anyone know the code that’s executed when you close a form using
the close button (bottom X)?

I have a switchboard that runs a few forms. When I’m in one of those
forms the switchboard remains open behind the scene. To close the
form I have a command button that simply executes DoCmd.Close acForm,
Me.Name. This works fine, but it’s a little slow (1 sec) and it looks
like the form is minimized and the switchboard is maximized (granted
this happens in a matter of 2 seconds.

The close button (bottom X) which I’ve left visible, is much faster
and simply eliminates the form and the switchboard just appears—unlike
the code I’m executing. It just seems much more efficient than the
code above.

I’ve tried other ways to close the form with the same result as
DoCmd.Close acForm, Me.Name, e.g., DoCmd.RunCommand acCmdCloseWindow
or DoCmd.RunCommand acCmdClose.

This may seem like a strange question, but I thought someone might
have experienced the same thing.

alex
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top