jwcolby
jwcolby at colbyconsulting.com
Tue Sep 7 12:27:33 CDT 2010
Terry, Since no one has offered anything... It surely sounds like a bug, although it may also be that this form is not opening modal or popup whereas one of the others you mentioned are. If that is the case, then this would be the expected behavior and your old application simply did not respond as it should have. Modal forms are supposed to be on top at all times and cannot lose the focus. Popups are supposed to start out on top but can lose the focus. Are any of the other forms mentioned being opened modal or popup? John W. Colby www.ColbyConsulting.com On 9/7/2010 12:29 AM, MACE, Terry wrote: > 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." >