I have set up a query by form to filter records for 4 reports. It works great... expect, now that I thought I was done, the client has change the rules...

For one of the reports there is a field in the criterial that she only wants the records if it is null. Unfortunatel the sql for the query by form says 'give me what is in the unbound control of the form or all records if the control is null'. (([tblCorpPltRgn].[Form/Rpt_No]) Like [forms]![frmReportFilter]![txtForm/Rpt_No] Or [forms]![frmReportFilter]![txtForm/Rpt_No] Is Null) Which is what she wants in three of the reports, but not the fourth one...

Any ideas???