[AccessD] Don't Open Form

Hollis,Virginia HollisVJ at pgdp.usec.com
Wed Feb 5 17:31:00 CST 2003


Getting tired. I wrote that backwards....
 
If the EvaluatorID IsNull I want the form to open, if the EvaluatorID has an
entry I do Not want the form to open.
 
I am looking for Requests that have not been assigned to an Evaluator.
 
Virginia

-----Original Message-----
From: Hollis,Virginia [mailto:HollisVJ at pgdp.usec.com]
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/dc0d629e/attachment-0002.html>


More information about the AccessD mailing list