[AccessD] Don't Open Form

If you Cancel the OnOpen you'll return an error (that User cancelled one
- 2501 off the top of my head) which you'll need to trap for in the
routine that opens the form.
 
 

Andy Lacey
http://www.minstersystems.co.uk <http://www.minstersystems.co.uk/> 



-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: 06 February 2003 01:00
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Don't Open Form


If you need to test from the form itself, do it in the Open event, which
has a Cancel argument.  It's cleaner just to avoid calling the form in
the first place though.
 
Charlotte Foust

-----Original Message-----
From: Hollis,Virginia [mailto:HollisVJ at pgdp.usec.com] 
Sent: Wednesday, February 05, 2003 3:31 PM
To: 'accessd at databaseadvisors.com'
Subject: RE: [AccessD] Don't Open Form


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/20030206/bb1b2892/attachment-0002.html>