[AccessD] Don't Open Form

Virginia,

If Not IsNull (Me.EvaluatorID) Then
    DoCmd.OpenForm
End If

Would this work?
 
Dan W
 
 
-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com] On Behalf Of Hollis,Virginia
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/9a63a6f5/attachment-0002.html>