[AccessD] Selection by Textbox Entries

Thanks Guys.  I'll look through your suggestions.  It looks like you all
have given me some good stuff.  I thank you for your time.  

Kindest Regards,

Keith E. Williamson | Assist. Controller| kwilliamson at rtkl.com

RTKL Associates Inc. | 901 South Bond Street | Baltimore, Maryland
21231-3305

410-537-6098 direct | 410-276-2136 fax | www.rtkl.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of A.D.TEJPAL
Sent: Friday, January 05, 2007 1:37 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Selection by Textbox Entries

Keith,

    My sample db named Form_Search might be of interest to you. It is
available at Rogers Access Library (other developers library). Link -
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Tejpal,A.D.
 
    It demonstrates search results based upon combined effect of
multiple combo boxes. Individual combo boxes can have any of the
following styles of values:
    (a) ALL
    (b) Some specific value
    (c) Wild cards as prefix and/or suffix

Best wishes,
A.D.Tejpal
---------------

  ----- Original Message ----- 
  From: Keith Williamson 
  To: Access Developers discussion and problem solving 
  Sent: Friday, January 05, 2007 22:27
  Subject: [AccessD] Selection by Textbox Entries


  Happy New Year All!! 

  I possibly have a simple question.  I have a form, that has at least
(3)
  input textboxes.  Based on criteria in these boxes, I am having the
form
  populate the recordsource with the appropriate data.  What I am not
sure
  of, is how to setup any of these boxes to NOT be included in the
  criteria either A) if they don't input anything; or B) input "All".  I
  could also do this as drop boxes, with one of the options being "All."
  But short of a bunch of nested IF statements....is there an easier way
  to create the select statement to NOT filter on one of these fields if
  that field either isnull or = "All"?? 

  Thanks, 

  Keith E. Williamson | Assist. Controller| kwilliamson at rtkl.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com