[AccessD] Strange Behaviour with Popup Forms in Acc2007

John,

None of the forms are modal but all are pop up. I've also found another area in the database that exhibits the same behaviour and it's also fired from a double-click event. All the ones that are fired from a command button work fine.
You may be right in that it is a bug.

Regards

Terry Mace
Logistics Support Officer & Maintenance Supervisor

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Wednesday, 8 September 2010 3:28 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Strange Behaviour with Popup Forms in Acc2007

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."
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
"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."