[AccessD] Strange Behaviour with Popup Forms in Acc2007

Hi all,

Our company is moving from Acc97 to Acc2007 and an app that I wrote a long time ago is behaving 'incorrectly' when converted to Acc2007.

I have a continuous form set to popup with a double-click field, which when clicked opens another popup form, which then opens a further form. In Acc97 each form opens one on top of the other as they should.

In Acc2007, the second form opens behind the first form and is not visible.  If the forms are moved around to get to the second form, the third form will then open on top of the others.

The forms that open on top are started from a command button, whereas the one that doesn't starts from a double-click text field.

The code that is not working is:
Private Sub Part_Number_DblClick(Cancel As Integer)
    DoCmd.OpenForm "frmItemSelect", , , , , , Me.Part_Number
End Sub

When stepping through the code, the form is in front until the End Sub statement is executed, when the form with the code comes back to the front.

Any ideas on getting the forms to open in the right order would be most appreciated.

Cheers

Terry

"Warning:
The information contained in this email and any attached files is
confidential to BAE Systems Australia. If you are not the intended
recipient, any use, disclosure or copying of this email or any
attachments is expressly prohibited.  If you have received this email
in error, please notify us immediately. VIRUS: Every care has been
taken to ensure this email and its attachments are virus free,
however, any loss or damage incurred in using this email is not the
sender's responsibility.  It is your responsibility to ensure virus
checks are completed before installing any data sent in this email to
your computer."