Close a form & return to Switchboard

[ScottXe]

I open a form via Switchboard. After use, I click the Close (X) button and would like to close the form and return to Switchboard. I tried to put below code in On Close event but failed. The Switchboard appears for a short period of time and then both the form and the Switchboard are close all together. Can someone advise me how to accomplish this task.

[June7]

What 'below code'? We need something to review. Provide code or database for analysis.

[ScottXe]

What 'below code'? We need something to review. Provide code or database for analysis.

Sorry for the omission.

DoCmd.OpenForm “Switchboard”

[June7]

That should work. Guess you better provide the db.

[Missinglinq]

...I click the Close (X) button and would like to close the form and return to Switchboard...

Just to be clear...you're talking about the Close (X) button on the secondary Form...not the Close (X) button on Access itself, correct?

And are talking about a switchboard generated by the Switchboard Manager?

Linq ;0)>

[ScottXe]

Thanks for your clarification. I checked it again. The users actually click the Close (X) button on Access itself since the form is in data sheet view where there are no Close, Restore down and Minimise buttons on the top right corner of the form. In data sheet view, how to close it?

[June7]

The restore/min/max buttons can be disabled and not displayed for a form in any view, including datasheet.

However, the X close button should always show for any form view. Question is - why don't you see it?

Unless BorderStyle property is set to None.

[Missinglinq]

In Form Design View

• Go to Properties - Format
• Set Control Box Property to Yes
• Set Close Button Property to Yes
• Set Border Style Property to anything except 'None'

Linq ;0)>

[June7]

Thank you linq - I never noticed ControlBox property - I can use that. I usually disable the X close button but annoyed that it still shows and I did not want None for BorderStyle.

[Sheba]

I have a button on my form and named it GO BACK. In the OnClick event, I have this code:

DoCmd.Close acForm, "yourformeName", acSaveYes
Forms!switchboard.Visible = True

It takes me back to the switchboard but of course, prior to this I disabled the Close button and enabled only the minimise button.

-just my 2 cents
hope this helps

[ScottXe]

I now locate the reason for disappearing the title bar with close (x) form feature. When I open the form to maximised, the title bar will disappear. Once I remove the statement of opening form to maximised, the title bar appears. It does not resolve the problem completely. If the user click the maximise button on title bar, the form will go to maximised and the close form button disappears again. The users do not have any way to close the form after the use and need to close the database. How can this be avoided?

[June7]

Deactivate the minimize/maximize.

[ScottXe]

Yes, that is my way of handling it currently. It is not perfect as the user cannot use the full screen. Thanks!

[June7]

If you want to allow full screen (I've never done this), maybe disable the X close and program a command button to close the form.

[ScottXe]

Thanks for all that responded. Problem resolved!