How to change the "stacking" order of Popup forms

[DawnTreader]

Hello all

i have a few forms that i need to have open and show up in a particular way.

the main form for my application is a pop up and takes up the entire
1280x1024 screen.

the second popup form i have opening at the "same" time is told to load by
the main form, but opens at basically the same time. when both forms have
finished loading the second form is under the first.

is there a way to tell access to bring the second form to the front?

 

[Dirk Goldgar]

Hello all

i have a few forms that i need to have open and show up in a particular
way.

the main form for my application is a pop up and takes up the entire
1280x1024 screen.

the second popup form i have opening at the "same" time is told to load by
the main form, but opens at basically the same time. when both forms have
finished loading the second form is under the first.

is there a way to tell access to bring the second form to the front?

You may have to use the main form's Timer event to open the second form.
For example, set the form's TimerInterval to some small value, such as 5,
and then have code in the Timer event like this:

Private Sub Form_Timer()

Me.TimerInterval = 0
DoCmd.OpenForm "YourSecondForm"

End Sub