OnClose event is triggered when opening form in laoyout mode. Why?

[newbieX]

Please explain why this scenario is occurring as I am baffled.

Below is the code I have on for the Data Entry Form OnClose Event on my form. I want to check to see if another form is open, and if not open it and then make it Visible. If the form is in layout view or design view then I don't want to automatically open the Main Menu Form. (Data Entry person should always have the Main Menu form open. Its visibility changes as the uses moves from one form to another.)
All forms are opened from the Navigation page for testing purposes.

Private Sub Form_Close()
Dim varTest As Integer
varTest = Me.Form.CurrentView
Debug.Print varTest
    If Me.Form.CurrentView = 1 Then
        Debug.Print "Form mode"
        If CurrentProject.AllForms("mnuMainMenu").IsLoaded = False Then
            Debug.Print "Main Form Closed"
            DoCmd.OpenForm ("mnuMainMenu")
        End If
    Else
        Debug.Print "Layout mode"
        Exit Sub
    End If
    Forms!mnuMainMenu.Visible = True

Scenario 1 (results as expected)
Both Main Menu Form and Data Entry Form are open in Form view. Intermediate window displays the following:

 1 
Form mode

Scenario 2 (results as expected)


Main Menu Form is Closed and Data Entry Form is open in Form view. Intermediate window displays the following:

 1 
Form mode
Main Form Closed

Scenario 3
Open and close Data Entry Form in Design view has no results in intermediate window regardless of whether Main Menu is open. (As expected)

Scenario 4

Main Menu Form is Closed and Data Entry Form is closed in layout view but was originally opened in Design view. Intermediate window displays the following when I close the form (As expected)

 7 
Layout mode

Now here is where it confuses me.
Scenario 5
Main Menu Form is Closed and I open the Data Entry Form in Layout view, this pops up in the intermediate window:

 1 
Form mode
Main Form Closed

And the Main Menu Form is opened.

When I close the Data Entry Form in layout view I get the following (As expected)

 7 
Layout mode

I think it is odd that when you open a form in layout view it triggers the OnClose event of the form. What is really going on in this instance?

[Micron]

I don't get #5. If I open a form in layout view but from the nav pane, then close it, of course the close event runs. But you're saying I open the Data Entry Form in Layout view (but not how or from what state it's being opened) and suggesting that code is running when the form is opened in that view. That would suggest you have form open code that runs only when layout is the view. I can't replicate the behavior you're experiencing, so maybe we'd need to see the code behind the entry form.

If I open as
design > form > close, close event runs
design > layout > close, close event runs
design > close, close event doesn't run
layout > form or form > layout, close event doesn't run (note, that means switching from form to layout or vice-versa isn't considered a form close)
layout > close or form > close, close event runs
That's what I would expect.

[newbieX]

I don't get #5 either. When I open the form from the navigation pane in layout view, the intermediate window displays the the debug.print information as described above right after I OPEN IT. I see this code

 1 
Form mode
Main Form Closed

BEFORE I close the form.

I don't get #5. If I open a form in layout view but from the nav pane, then close it, of course the close event runs. But you're saying I open the Data Entry Form in Layout view (but not how or from what state it's being opened) and suggesting that code is running when the form is opened in that view. That would suggest you have form open code that runs only when layout is the view. I can't replicate the behavior you're experiencing, so maybe we'd need to see the code behind the entry form.

If I open as
design > form > close, close event runs
design > layout > close, close event runs
design > close, close event doesn't run
layout > form or form > layout, close event doesn't run (note, that means switching from form to layout or vice-versa isn't considered a form close)
layout > close or form > close, close event runs
That's what I would expect.

[Micron]

then you must have event code for open or load events.

so maybe we'd need to see the code behind the entry form.

In absence of the aforementioned, I don't see what else I have to offer. Sorry.

[newbieX]

I am not sure I started a new thread or not. This was the only way I could figure out how to attach database demonstrating my issue.

In reference to:

https://www.accessforums.net/showthread.php?t=66083

I have attached stripped down database to show you what is occurring.

I do not see what it is that is causing this issue.

[Micron]

I should have suggested you put breaks on all the pertinent events so you could follow them. When opening as you state in scenario 5 this is what I see:
opening entry form in layout view from nav pane:
the open event runs
the load event runs (I don't put non-data related property settings in the load event)
the close event runs where it says, 'if main menu is not loaded, then open it'
(this is likely where it switches from design view to layout. I've never checked, but perhaps this is the usual behaviour)
main menu open event runs
at setfocus line, execution branches to load event, completes it & returns to open event
data entry form open event runs again (probably as a result of switching to another view at this point)

If you interrupt the process by stopping the code you'll get a system message about having to close the window as the view switch cannot be completed. I don't recall at what point I did this, but you can play with it following the above and likely figure out which view it was going to based on your immediate window.

So unless you expect users to be opening forms in layout view, you shouldn't have an issue. Otherwise, I guess you have to tweak the process.

[newbieX]

I do not expect this to be a real issue. I just thought it odd and wanted to know what was different about using Layout view than Form and Design view. Coding is easier when you understand the inner workings and this one had me baffled. Thanks for helping.

[Micron]

Seems like this has to do with the order of events. Looks like the form actually closes and reopens when being opened from the nav pane in layout view, which surprises me. I think when I wrote this is likely where it switches from design view to layout I think I meant switches from normal to layout. Your open & load code wouldn't have run if opened in design view. You might want to check this out
https://support.office.com/en-us/art...7-CE86553682F9
so you have some idea of the order of events. It will come in handy, but I see nothing there about what happens when you open a form in design view. If your code is an issue, you'll have to figure out a tweak that prevents it. One way is to pass a value in the form's OpenArgs when the form is opened by user action from another form. If the property has no value when the form opens, bypass the code and maybe close it or disable controls instead.