Close Button for Popup, non-modal from

[P5C768]

I'm trying to track down a problem I'm having with a popup non-modal form that for whatever reason, when the form is closed, Access is minimized and the most recently used window is opened (even a non-Microsoft program will be maximized).

The problem started when I tried to convert some VBA code (which was working) to an embedded macro:

Sub Command10_Click()
    DoCmd.Close
    DoCmd.OpenForm "MainMenu_frm"
    DoCmd.Maximize
End Sub

I tried the embedded macro option using just close, then close and open form, but every time I click the close button, it would minimize access. So I went back to the vba code above. However, now the VBA code cause the same issue. I am using Access 2007, with tabbed documents and I ran a compact and repair to no avail. Any ideas?

Thanks!

[ssanfu]

I never use macros, so I have no idea what the macro would be doing.

I would delete the button, do a compact and repair, then create the button again. Make sure the click event has [Event Procedure] displayed. Re-enter the code but try

DoCmd.Close acForm, Me.Name
DoCmd.OpenForm "MainMenu_frm"
DoCmd.Maximize

"Command10" is not a good name (IMO - not descriptive)... I take the time to name objects; in this case I would name the button "cmdClose" or 'btnClose".

[P5C768]

That is basically what I have already done, I tried deleting the button and using the code you provided but I still get the same result. I also tried changing the form to not be pop-up and turning off tabbed documents, each with no effect.

[ssanfu]

Then I would try import the objects to a new database. Sounds like corruption....

If that doesn't work, delete and re-create the form.

Do you have the "Always use Events" check box checked in the options? And "Autocorrupt" is unchecked? OOPS, I mean "Autocorrect".