[AccessD] Weird Form_Close

Thanks to both of you.
A.

On Mon, Jun 25, 2012 at 10:31 AM, William Benson <vbacreations at gmail.com>wrote:

> 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
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Arthur
Cell: 647.710.1314

Prediction is difficult, especially of the future.
  -- Niels Bohr