Sub-Query not reflecting changes to the master Query 1

[garyc]

Error in Access 2007:

Changes to criteria in a query used as master query are not reflected in
sub-queries (which refer directly, and only, to that master query) unless the
database is closed then re-opened. Why?

I'm using XL professional, have 1gb ram, Access 2007 installed as part of
Office 2007. I'm using one table; all of my sub-queries refer to a master
query within my database.

Ex: If I make a change to my master query so that it collects a limited
range of dates, and then switch to a sub-query referring to that master, the
change in records shown in the master is not reflected in the sub-query.

In my testing, I created a new db with just a handful of records and a
couple of queries. The 'error' still occurred, so I ruled out that I had too
many queries or too many records. I then tried repairing and compressing the
db and the 'error' still occurred.

In previous versions of Access, the change to a master query always
immediately affected any sub-queries that referred to the master query so I
would expect 2007 to react in the same manner.
Has anyone had this occur and found a solution?
Thanks,
--
Gary

 

[SkipVought]

Please post in one of the MANY MS Access Forums.

Skip,
[sub]
I'll be dressed to the nines this week, as I go to have my prostatectomy...
Because, if I'm gonna BE impotent, I want to LOOK impotent![/sub]