close form

[mike wild]

I am starting a new project.

I have 9 forms and any ONE form could be open.
I have 9 option buttons which opens the forms. When the user clicks option button one, forms one opens but i need to close the other open form.

How do i to declare (dim) the current open form? so that i can open the new form first, and then close the dimed form?

Any suggestions would be great

 

[mike wild]

yes, but any one of the 9 forms could be open.

 

[ghudson]

You should close your main menu form that you use to navigate to each form. Only keep open the current form.

    DoCmd.OpenForm "AnotherForm"
    DoCmd.Close acForm, Me.Name

 

[mike wild]

ghudson,

i tried that earlier and it just closes the form you've just opened.

which is why i was tring to record the name of the current open form in a dim statement, so that i'll be able to close it whneever.

 

[ghudson]

Not sure how and were you are running the code from but you are not doing it right for I use that code in all my applications to close the form that the code is run from after the next form is opened.

Say I have a main menu form named frmMainMenu. I have a command button named btnOpenAnotherForm on the main menu form. That command button is supposed to close the main menu form and open another form named frmAnotherForm. I place this code in the OnClick event of the btnOpenAnotherForm button.

    DoCmd.OpenForm "frmAnotherForm"
    DoCmd.Close acForm, Me.Name

That code will first open the frmAnotherForm form then it will close the frmMainMenu form. The Me.Name refers to the frmMainMenu form because the code was called from that form.

 

[mike wild]

It works now. Thank you all.

 

[andyski101]

If your coding this in a module and not on a specific form then the

DoCmd.Close ac Form, Me.Form

will close the form on top, and I think that's what your saying your problem is right?

If this is the case, you could have Form Load store the name of the form in a public variable and call that.

DoCmd.Close acForm, strForm

If you put ghudson's code on the On Close of each form then it should work. Given how little code is needed this might be the better option, unless your doing other things on close you haven't told us about.