I have a form set up for the user to enter the parameters for an underlying query. The first text box asks for a report number, and the second asks for a name. If they enter one or the other, it works great. I would like to add the option for the user to leave both boxes blank to see the most recent report built upon the query. When I try it now, I just get a blank report. The Report Number field in the query is sorted decending, so the first record would be the most recent report. How can I set up this third option to work correctly?
Thanks for your help.