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>