I have a popup form enabling selection of criteria for a report. The report recordsource is a query that contains criteria from the popup form such as
The form contains two combo boxes, each using a UNION query to allow an 'All' records selection similar to the following:
SELECT first record selection UNION SELECT "Is Not Null", "(All)" AS Name from tblCrews ORDER BY Name;
Each combobox shows the All value, and it equates to "Is Not Null" in a query. However when I put [Forms]![frmPrintTimeCards]![cboCrewID] in as a criteria on the report recordsource query and choose 'All' from the combobox (Forms![frmPrintTimeCards]![cboCrewID] value is 'Is Not Null'), the query comes up with no records. FYI, the field I put the criteria in is a text field.
Last edited by rdperkins; 09-03-13 at 17:15.