Search Query return nothing if creterias were not all entered - HELP!

[CSCS]

Hi,

In my search form I have 5 creterias and in the query behind it I joined them by AND. the problem is if the user entered only 2 or 3 of those creterias, the query will not return anything.

how can I slove that?


your responses are very appreciated.

Regards,
CS.

 

[clerics]

Take a look in this , It ll help you solving your problem

http://www.access-programmers.co.uk/forums/showthread.php?t=103326

or this one

http://www.access-programmers.co.uk/forums/showthread.php?t=102798


Good luck

 

[EMP]

Or this thread in the sample databases forum:

Query By Form - using Text Boxes and Combo Boxes in criteria
http://www.access-programmers.co.uk/forums/showthread.php?t=103312

^