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
>