[AccessD] Debugging problem

Arthur,

 As Charles said, in the OnOpen controls are being created so you need to
move the code. Although I would not place code in the OnCurrent, but rather
OnLoad.  At that point, all controls have been created.

 Note to that you can still do this in OnOpen if you'd like by placing a
Me.Repaint just before the control check.  This will force Access to finish
creating the controls before continuing.

Jim Dettman
President,
Online Computer Services of WNY, Inc.
(315) 699-3443
jimdettman at earthlink.net

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Arthur Fuller
Sent: Thursday, April 10, 2003 9:07 AM
To: AccessD
Subject: [AccessD] Debugging problem


I'm doing some work on a colleague's app and coming across something very
weird. In a Form_Open event, there's a line to test the value of Faculty_ID
and then make a decision based on it. The app crashes there and the error
message is:
	Run time error 2427
	You entered an expression that has no value

Yet when I ask IsNull(Me.Faculty_ID) the answer is False.

How can both things be true?

I've seen this happen before but it was long ago and I don't remember how I
fixed it.

Ideas?

TIA,
Arthur

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