Form in the Background

[UT227]

I was wondering if there was a way to keep my main menu on the background and no windows allowed to be behind it. Kind of like having the main menu as the wallpaper of that database.

[CJ_London]

there is code to force a form window to be on top (besides using popup and modal properties), but that is not the same as keeping a form at the back.

Suggest an alternative method is maximise your main form and have all your other forms appear in a subform 'window'

say this subform control is call sfWindow

then instead of using

docmd.openform "myform"

use

me.sfwindow.sourceobject="myform"

and if you are using openargs, Where etc, apply to the now open form instead or have the form check against the parent (i.e. your main menu form) instead in the open, load or current events

[UT227]

I have so much to learn. I use the built in buttons which use the macros to open new windows.

[CJ_London]

macros are quite limited compared with what you can do with code. So perhaps time to get stuck in!