[AccessD] Don't Open Form

If you need to test from the form itself, do it in the Open event, which
has a Cancel argument.  It's cleaner just to avoid calling the form in
the first place though.
 
Charlotte Foust

	-----Original Message-----
	From: Hollis,Virginia [mailto:HollisVJ at pgdp.usec.com] 
	Sent: Wednesday, February 05, 2003 3:31 PM
	To: 'accessd at databaseadvisors.com'
	Subject: RE: [AccessD] Don't Open Form
	
	
	Getting tired. I wrote that backwards....
	 
	If the EvaluatorID IsNull I want the form to open, if the
EvaluatorID has an entry I do Not want the form to open.
	 
	I am looking for Requests that have not been assigned to an
Evaluator.
	 
	Virginia

		-----Original Message-----
		From: Hollis,Virginia [mailto:HollisVJ at pgdp.usec.com]
		Sent: Wednesday, February 05, 2003 5:25 PM
		To: 'accessd at databaseadvisors.com'
		Subject: [AccessD] Don't Open Form
		
		
		Ok, what is the trick to prevent a form from opening if
it does not meet certain criteria? If the EvaluatorID on the form does
not have an entry, I do not want the form to open, but give a message
"All assigned".
		 
		If IsNull (Me.EvaluatorID) Then
		    Do not Open
		 
		Virginia

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030205/d6b13e34/attachment-0002.html>