Date field in search form

[CGC]

I have been working on a search form for a week now and seem to have everything working with a couple of exceptions. I now need to add the ability to allow the user to search on a date field as well as a yes/no field (set up as a checkbox on the data entry form.) My search form is an unbound form. Everything I tried in the date field just returns all records - it does not see my date. Any ideas on how I can set these two type fields as searchable fields? Thanks for your suggestions!

 

[saintsman]

Base your form on a query, even if it just shows all the fields in your table.
Then you can write in the Date field of your query the following condition as the criteria [Enter Date Required]. (Change the wording if required but you must use the square brackets). What will happen is the form will prompt you for the date when it is opened.
Have a play to get it to show what you want.

 

[CGC]

That does work, however the problem is that they want this form to be searchable on one or all fields. So they may or may not want to search on the date field. If I set it up this way, they will have to put a date in and they may not want to search on that field. Anything else I could try? If I can get this and the checkboxes figured out, I'll be done with this thing!