I have report whose data source is query3 based on a 4 fields from a query1 and one field from query2. When creating the report, the field from the query2 will display but if I close the database and reopen it, the control source for the field on the report reverts to the field name from query2's source table instead of the field name from query2. As a result, I get an error and my report won't open. What am I missing? Thanks.
Last edited:
