Display order of forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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...
 
Back
Top