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

More symptoms... the form is open in the background of the form which called it (as I said) but I cannot type anything in the VBA window, I cannot click on its title bar, I cannot even click on the calling form which "looks" like it is active -- the title bar is highlit. So it is almost like Access/VBA is in some kind of suspense.

Suggestions for debugging?

-----Original Message-----
From: Benson, William (GE Global Research, consultant) 
Sent: Wednesday, March 21, 2012 11:53 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: 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