Default the search criteria in the form field.  Then the form will pass the default 
value to the query unless another is entered/selected.

...Jon 

------Original Message------
From: LH Rothman <[EMAIL PROTECTED]>
To: CF Talk <[EMAIL PROTECTED]>
Sent: August 21, 2000 4:30:40 PM GMT
Subject: Minimum Search Criteria


I've got a search interface w/ multiple criteria and it works great.
However, if the user selects NO options, all records in the database
appear.  How do I force the user into selecting a MINIMUM of 1 search
criteria or else an error message of some type appears?

Thank you!
-Laura (Newbie)

------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

-----------------------------------------------
FREE! The World's Best Email Address @email.com
Reserve your name now at http://www.email.com


------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Reply via email to