How to stop form openiing in different windows??

[1masc]

Hi there everyone,
Must be a really simple one, this one but can't seem to find the solution!

Can someone put me out of my missery and tell me how to make each form open in the same window instead of ending up with millions of open windows??!!
Thanks, Matt

 

[statsman]

My method attacks the problem from a different angle.
Close each form when you're finished with it.

Example: finished updating or entering records. Place a command button to close the form. This only leaves one form open all the time. The switchboard. When you close the forms you always return to the switchboard.

 

[1masc]

Thanks for the response,
Do I need to add a command to the event of each button that could be used to navigate away from the form?
If so, do you have the applicable code?
Many thanks, Matt

 

[statsman]

The trick is to run everything off your switchboard or menu.
When you create the Close Form command button, you can do it using the wizard which will handle all the coding for you.

As the switchboard is still open, you should be returned there.

If you are using a form to select the criteria for a record search (example: entering a name to find that person's record for editing or deletion), be sure to close the form when you run the macro or include closing the form in the event procedure,

 

[1masc]

Anyt chance you give me an exaple of code to close the form that i could use in the event procedures?
Thanks for your help

 

[Pat Hartman]

Or, if you are talking about windows in your taskbar, you can turn them off by opening the Tools/Options dialog.

 

[ghudson]

Here is the code to open another form and close the form that the code is run from...

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

Now to really fix your problem [tell me how to make each form open in the same window instead of ending up with millions of open windows?] you need to run this code just once when your application is first opened...

Application.SetOption "ShowWindowsinTaskbar", False

You can find more goodies like that in my Hide all Access Toolbars and Menubars thread.