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

Benson, William (GE Global Research, consultant) Benson at ge.com
Wed Mar 21 23:09:24 CDT 2012


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?



More information about the AccessD mailing list