Come with experience from another well known relational database application but an Access virgin so please be patient!
I have designed labels based on a query. However, if I filter the query to select a subset of records then reopen the report the labels only list all the records from the base table. Thinking a 'refresh' might simply be required to reset all the relationships I tried the 'Refresh All' button but this doesn't change the labels report to show the updated, filtered query. However, if I show the report properties in design view, choose another query based on the same table and then go back and simply choose the correct, now filtered query as the record source the filters are reset appropriately and the labels update successfully. Although this action works it doesn't seem right. Why doesn't 'Refresh All' apply the new query filter to the opened report? What should I be doing?