OK, I think this problem belongs here. I was having a problem on a form but traced it down to this.
Why would one query show a change in a field when an underlying table is edited without the query having to be re-run(it is open in datasheet view), but another query that's very similar not reflect the change in the table until it is rerun?
Why would one query show a change in a field when an underlying table is edited without the query having to be re-run(it is open in datasheet view), but another query that's very similar not reflect the change in the table until it is rerun?
