[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

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

410-537-6098 direct | 410-276-2136 fax | www.rtkl.com
<http://www.rtkl.com/>