Second form appears behind the first

[Kiers]

Hi All,

I have a form with a button that when selected opens a second form,
which appears behind the first - neither form has modal or popup set
to 'yes'. Can someone please explain why this is happening and how to
prevent it?

the command to trigger the second form is

DoCmd.OpenForm "frmOrder", acNormal, , "ID = " & Me!
sfrInProgress.Form.Controls!OrderID, acFormEdit, acWindowNormal

Rgds

Kiers

 

[Tom van Stiphout]

On Wed, 1 Oct 2008 05:00:25 -0700 (PDT), Kiers

This one looks fine. How about the code for the first one?

-Tom.
Microsoft Access MVP

 

[Kiers]

On Wed, 1 Oct 2008 05:00:25 -0700 (PDT), Kiers


This one looks fine. How about the code for the first one?

-Tom.
Microsoft Access MVP







- Show quoted text -

Tom,

thanks - the answer is in your question

'hidden' in the basRibbonCallbacks code I found;

DoCmd.OpenForm "frmOrdersall", acNormal, , , acDialog

I have now changed it to acWindowNormal and all is well

Thanks Again

Kiers