Query as a source record works fine but I now want to use multiple queries, may be use a case statement, but the VBA statement is not passing the query. Seems like joined tables to main table in the query is not being seen. Opening the Report has event that opens a dialog box for filter selection and from this form criteria is sent to Query filtering report. Query run by itself works and returns only two records. VBA automation returns thousands or ALL records. Query is not being used in the process obviously. What should the Report record source be? I usually use the main table, what should be the source when opening and calling for a query to provide source?