Make Form Button close current form and bring switchboard to foreground

[ghadley_00]

Hi,

Can anyone recommend a piece of VBA code I could attach to a button in
a MS Form form that will close the current form and bring the
switchboard to foreground. I'm trying to integrate a form of buttons
into the way the switchboard gets used.

Best wishes,

George Hadley
gh********@yahoo.com

[Keith Wilby]

<gh********@yahoo.com> wrote in message
news:11**********************@p10g2000cwp.googlegr oups.com...

Hi,

Can anyone recommend a piece of VBA code I could attach to a button in
a MS Form form that will close the current form and bring the
switchboard to foreground. I'm trying to integrate a form of buttons
into the way the switchboard gets used.

Best wishes,

George Hadley
gh********@yahoo.com

George,

You don't really need a "close form" button. Hide your switchboard form
when your
target form opens and unhide it when it closes. In the target form's open
event:

Forms("frmSwitchboard").Visible = False

In the form's close event:

Forms("frmSwitchboard").Visible = True

It's a bit clunky in that it will cause an error if the switchboard form
isn't loaded but it should work otherwise.

Keith.
www.keithwilby.com

[Lyle Fairfield]

Form_frmSwitchboard.Visible = False/True
should avoid the error and open the form if it is not loaded (and not
open it if it is).
This assumes frmSwitchboard's HasModule Property is True. I assume it
will be True for a Switchboard.

[Keith Wilby]

"Lyle Fairfield" <ly***********@aim.com> wrote in message
news:11**********************@z34g2000cwc.googlegr oups.com...

Form_frmSwitchboard.Visible = False/True
should avoid the error and open the form if it is not loaded (and not
open it if it is).
This assumes frmSwitchboard's HasModule Property is True. I assume it
will be True for a Switchboard.

Didn't realise that Lyle, thanks for the info.

Keith.

[salad]

gh********@yahoo.com wrote:

Hi,

Can anyone recommend a piece of VBA code I could attach to a button in
a MS Form form that will close the current form and bring the
switchboard to foreground. I'm trying to integrate a form of buttons
into the way the switchboard gets used.

Best wishes,

George Hadley
gh********@yahoo.com

To close the current form you can enter something like
Docmd.Close acForm,Me.Name
and to select the Switchboard
Docmd.SelectObject acForm,"SwitchboardFormName"