<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1126" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=475113923-05022003><FONT face=Arial color=#0000ff
size=2>Virginia,</FONT></SPAN></DIV>
<DIV><SPAN class=475113923-05022003>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><FONT face=Arial size=2><SPAN class=360432023-05022003>If <SPAN
class=475113923-05022003><FONT color=#0000ff>Not</FONT> </SPAN>IsNull
(Me.EvaluatorID) Then</SPAN></FONT></DIV>
<DIV><SPAN class=360432023-05022003><FONT face=Arial><FONT
size=2> <SPAN
class=475113923-05022003>DoCmd.OpenForm</SPAN></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=360432023-05022003><FONT face=Arial><FONT size=2><SPAN
class=475113923-05022003>End If</SPAN></FONT></FONT></SPAN></DIV></BLOCKQUOTE>
<DIV><SPAN class=360432023-05022003><FONT face=Arial><FONT size=2><SPAN
class=475113923-05022003>Would this work?</SPAN></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=360432023-05022003><FONT face=Arial><FONT size=2><SPAN
class=475113923-05022003></SPAN></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=360432023-05022003><FONT face=Arial><FONT size=2><SPAN
class=475113923-05022003>Dan W</SPAN></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=360432023-05022003><FONT face=Arial><FONT size=2><SPAN
class=475113923-05022003></SPAN></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=360432023-05022003><FONT face=Arial><FONT size=2><SPAN
class=475113923-05022003></SPAN></FONT></FONT></SPAN></SPAN> </DIV>
<DIV></DIV>
<DIV><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>Hollis,Virginia<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>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<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>