<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.00.3314.2100" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=180482623-05022003>Getting tired. I wrote that
backwards....</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=180482623-05022003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial 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 color=#0000ff face=Arial size=2><SPAN
class=180482623-05022003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=180482623-05022003>I am
looking for Requests that have not been assigned to an
Evaluator.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=180482623-05022003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=180482623-05022003>Virginia</SPAN></FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV align=left class=OutlookMessageHeader dir=ltr><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></BODY></HTML>