<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2713.1100" name=GENERATOR></HEAD>
<BODY>
<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></BODY></HTML>