Stuart McLachlan
stuart at lexacorp.com.pg
Wed Mar 21 23:13:59 CDT 2012
<quote> acDialog The form's Modal and PopUp properties are set to Yes. </quote> So the correct answer to my previous question: Is the the Popup property of the front form set to Yes? Was "Yes" :-) -- Stuart On 22 Mar 2012 at 4:09, Benson, William (GE Global Re wrote: > I cannot believe I missed this (and forgot to check it) ... I was opening the first form using acDialog. Doh! > > Justifies its not allowing me to see anything behind it. > > EXCEPT THAT IT SOMETIMES WOULD ... (which kinda threw me off the scent). > > So now I have to apologize for wasting anyone's time. > Bill > > -----Original Message----- > From: Benson, William (GE Global Research, consultant) > Sent: Thursday, March 22, 2012 12:00 AM > To: 'Access Developers discussion and problem solving' > Subject: RE: Access 2010 cannot get at the form I opened. > > Could it be because I declared the calling form as a form level variable within the code module of the called form and then try to reference one of its controls? > > Option Compare Database > Option Explicit > Dim frmEnterSolarEquipment As Form > > Private Sub Form_Load() > txtSerialNumber = Nz(frmEnterSolarEquipment).Controls("EQUIP_SERIAL_NUMBER"), "") End Sub > > Private Sub Form_Open(Cancel As Integer) Set frmEnterSolarEquipment = Forms("Enter Solar Equipment") End Sub > > -----Original Message----- > From: Benson, William (GE Global Research, consultant) > Sent: Wednesday, March 21, 2012 11:55 PM > To: 'Access Developers discussion and problem solving' > Subject: RE: 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? > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >