[AccessD] Weird Form_Close

If you only want to "open" the form if it were already open you can

set Frm = Forms("formname")

If not frm is Nothing then
  Docmd.OpenForm "formname"
End if

BILL
On Jun 25, 2012 10:25 AM, "Charlotte Foust" <charlotte.foust at gmail.com>
wrote:

> DoCmd.OpenForm should work even when the form is open.  It doesn't matter
> if the database window is hidden.
>
> Charlotte Foust
>
> On Mon, Jun 25, 2012 at 6:41 AM, Arthur Fuller <fuller.artful at gmail.com
> >wrote:
>
> > I have a weird problem I cannot trace. There's a switchboard and four
> > forms. One works correctly, opening and closing  and we're back to the
> > switchboard. The other three open and close and suddenly the switchboard
> is
> > hidden! I've compared the Open and Load events and can see no meaningful
> > differences.
> >
> > However, I vaguely recall a workaround that did something like select the
> > form in the database window. I don't remember the code and I'm not sure
> it
> > would work anyway, since the database window is hidden too.
> >
> > What is the code equivalent to "unhide a window"? Until I resolve this, I
> > could work around the problem using that.
> >
> > TIA,
> >
> > --
> > Arthur
> > Cell: 647.710.1314
> >
> > As lousy as things are now, tomorrow they will be somebody's good old
> days.
> >
> > - Gerald Barzan
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> >
> >
> > Website: http://www.databaseadvisors.com
> >
> >
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>