Display order of forms

C

Connie

Hi, does anyone know how to set it so that if you have a number of
windows/forms open, everytime you open a for/window, it willl be displayed at
the front? as its displaying them behind the other forms at the moment
Thanks
 
A

Allen Browne

Make sure the Popup and Modal properties of your forms are set to No.

Then the most recently opened form will appear in front when you open
it--unless it is already open. In that case you can use SetFocus to make it
the active form, e.g.:
DoCmd.OpenForm "Form1"
Forms("Form1").SetFocus
 
C

Connie

Thanks for that :)

Allen Browne said:
Make sure the Popup and Modal properties of your forms are set to No.

Then the most recently opened form will appear in front when you open
it--unless it is already open. In that case you can use SetFocus to make it
the active form, e.g.:
DoCmd.OpenForm "Form1"
Forms("Form1").SetFocus
Click to expand...
 
Top