I have a query on an inventory like table which collects all fields that have the "Taken?" Yes/No field set to Yes, and the "Returned?" field set to No, to trace any items out on loan, which have been collected and not yet returned. If I have an item showing as out in the query, then I set the returned field in the original table to Yes, the query does not update, even if I enter design view and run it again, or press the refresh all button. Access 2007, if that helps.
Thanks.
EDIT: If I enter a new record into the original table, then "Refresh All", the query updates, but it does not if I "Refresh All" having only changed the value of a "Yes/No" filed. The report from the query sometimes updates without the query itself updating, but if I change two Yes/No fields before refreshing, only one will appear in the report.