[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