[AccessD] Access 2010 cannot get at the form I opened.

And................. now it is not working again. Even though I did (I thought prudently) go back and put AcNormal on the command line. Which obviously (now I can tell) is not the solution. And it means something else sinister, reeeeeaaaaallllly sinister is going on.

-----Original Message-----
From: Benson, William (GE Global Research, consultant) 
Sent: Wednesday, March 21, 2012 11:39 PM
To: Access Developers discussion and problem solving
Subject: RE: Access 2010 cannot get at the form I opened.

OK, who is going to believe this...

I changed the code which opened the form from


Private Sub cmdSelectEquipment_Click()
DoCmd.OpenForm "Choose Equipment Form"
End Sub



To


Private Sub cmdSelectEquipment_Click()
DoCmd.OpenForm "Choose Equipment Form", acNormal End Sub

And then it was no problem.

Furthermore I thereafter removed
, acNormal

And it still worked.


Does the DoCmd.OpenForm  command work like the Find method in Excel works, where certain parameters in the method are retained and inferred the next time the DoCmd.OpenForm is executed if insufficient arguments are used to over-ride what was used the previous time?




-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Benson, William (GE Global Research, consultant)
Sent: Wednesday, March 21, 2012 11:24 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Access 2010 cannot get at the form I opened.

I open a form from a button click, and that form is opening behind the one with the button that I clicked. Therefore I cannot see its data.

Modal on both forms is "No"

I cannot get at the form in the background to complete work, any idea what is happening? 

I am not using tabbed forms.

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com