[AccessD] Don't Open Form

Don't read it from the form. Look up the record in the source table and either open the 
form or display a message box depending on the presence of the data.


> 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
> 
> 


-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System Support.