Multiple Search fields in Form

[bikeshox13]

I am attempting to make a form where you can enter in a date range and another field that will then run in a query after clicking a button.

If I query by just name nothing gets returned

If I query by name and by date I get the results I am looking for

If I query by date range nothing gets returned.

I would like to be able to enter just a name, just a date range and/or both. Any Ideas?

 

[llkhoutx]

Create a popup form which builds your filter criteria and stores it in a textbox on your form (popup and calling form) for use, based upon textbox values populated on the popup.