Closing form, return contol to menu form

[ssissons]

I have an Access 2007 database with multiple forms, so I created a menu form. It calls the sub-forms correctly. But, when I want to exit the sub-form, I want control passed back to the menu. What is the command to do that? I have tried "DoCmd.Close" and "DoCmd.Close acform, Me.Name", but both completely close the DB, not just the form. If that is the right command, what parms do I use to close JUST the current form?

Private Sub Exit_Click()
DoCmd.Close acForm, Me.Name

End Sub

[pbaldy]

Either of those should close just the form, so something else seems to be going on. Is there other code in the form that might be closing the db? No error message happens, it just closes the db?

[ItsMe]

I guess
DoCmd.Close acForm, Me.Name
will close the current form.

I usually do this
DoCmd.Close acForm, "FormName"

If you have a form named frmMenu and you want to interact with it from another form's module, you could do something like this
DoCmd.OpenForm "frmMenu"
DoCmd.Close acForm, "FormName"

even if frmMenu is already open, it will set focus on frmMenu. Because focus is on frmMenu, you need to be explicit and name the form you want to close. Docmd will default to the object with current focus if you do not explicitly tell it otherwise.

[ssissons]

Either of those should close just the form, so something else seems to be going on. Is there other code in the form that might be closing the db? No error message happens, it just closes the db?

No error message. And, that is the only Sub that closes the form.

[pbaldy]

Can you post the db here? That code shouldn't close the db.

[ssissons]

Nope, that didn't work for me. Same results. Here is my code

Private Sub Exit_Click()

DoCmd.Openform "Menu"
DoCmd.Close acForm, "LTCBACK_Entry"

End Sub

[ssissons]

Cant post the DB - company doesn't allow that.

[pbaldy]

Well, I'm not sure what to say. I have similar code in every db I've ever built, and it never closes the entire db. You need Quit to do that, so you may want to search for that in VBA. Failing that, you may have some sort of corruption.

[ItsMe]

Like Paul mentioned, something else is going on that is telling Access to quit. Maybe you have an embedded macro in your click event or whatever event you are writing your VBA in. An embedded macro will trump code in the VBA module.

Somewhere, there is a .Quit method executing

[ssissons]

I did a search through the DB - there were a couple of .QUIT statements, but not in the forms I was testing. I have now changed it so that the only .Quit is in the Menu form -- same result.

[ssissons]

Sorry, guys. Apparently, my VB/Access skills have some serious holes. The buttons that are controlling what sub-form is executed had "Embedded Macro" in the On_Click event, and it was set to a different form than intended. I've got that all straightened out, and it is working correctly now. Thanks for your help!!

[pbaldy]

Glad you got it sorted out.