<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1126" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=780344818-06022003><FONT face=Arial color=#0000ff size=2>If you
Cancel the OnOpen you'll return an error (that User cancelled one - 2501 off the
top of my head) which you'll need to trap for in the routine that opens the
form.</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV> </DIV><!-- Converted from text/plain format -->
<P><FONT size=2>Andy Lacey<BR><A
href="http://www.minstersystems.co.uk/">http://www.minstersystems.co.uk</A><BR><BR></FONT></P>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-admin@databaseadvisors.com [mailto:accessd-admin@databaseadvisors.com]
<B>On Behalf Of </B>Charlotte Foust<BR><B>Sent:</B> 06 February 2003
01:00<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> RE:
[AccessD] Don't Open Form<BR><BR></FONT></DIV>
<DIV><SPAN class=788135900-06022003><FONT face="Comic Sans MS" color=#0000ff
size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=788135900-06022003><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=788135900-06022003><FONT face="Comic Sans MS" color=#0000ff
size=2>Charlotte Foust</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
Hollis,Virginia [mailto:HollisVJ@pgdp.usec.com] <BR><B>Sent:</B> Wednesday,
February 05, 2003 3:31 PM<BR><B>To:</B>
'accessd@databaseadvisors.com'<BR><B>Subject:</B> RE: [AccessD] Don't Open
Form<BR><BR></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=180482623-05022003>Getting tired. I wrote that
backwards....</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=180482623-05022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=180482623-05022003>If
the EvaluatorID IsNull I want the form to open, if the EvaluatorID has an
entry I do <U>Not</U> want the form to open.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=180482623-05022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=180482623-05022003>I
am looking for Requests that have not been assigned to an
Evaluator.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=180482623-05022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=180482623-05022003>Virginia</SPAN></FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Hollis,Virginia
[mailto:HollisVJ@pgdp.usec.com]<BR><B>Sent:</B> Wednesday, February 05,
2003 5:25 PM<BR><B>To:</B>
'accessd@databaseadvisors.com'<BR><B>Subject:</B> [AccessD] Don't Open
Form<BR><BR></DIV></FONT>
<DIV><FONT face=Arial size=2><SPAN class=360432023-05022003>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".</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=360432023-05022003>If IsNull
(Me.EvaluatorID) Then</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=360432023-05022003> Do not
Open</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=360432023-05022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=360432023-05022003>Virginia</SPAN></FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>