I have created a Form from which a user can select the data to use in a Report regarding several buildings. Within the database there is a table for the Facilities (tbl_Facilities). Each Facility may contain several buildings (tbl_Buildings).
The form allows the user to select by FacilityType, County, and/or BuildingType; and I would like to allow the user to select "all". My question is how I can build this flexibility into the select query that is the data source for the report?
For example, I can set the select criteria for FacilityType to be Forms!frm_ReportMenu!txtFacilityType; and so long as that control contains data, the query works fine. But how can I set up the query to return all records if the field is left blank?
TIA.