I have built a form similar to Rick's search form to generate a report. Everything works as designed. One of my criteria takes values from StartDate and EndDate textboxes  in the form as so:

>=[Forms]![ReportDesignF]![StartDate] And <[Forms]![ReportDesignF]![EndDate]

All of the other report criteria have the wild card options as Rick taught so that leaving the option blank returns all records, but I can't seem to get this to work with the date criteria. I'm guessing I just don't understand how to properly concatenate the wild card with the query as written. This forces the user to put dates in the text boxes or they get a blank report. Can anybody point me in the right direction?