Hi Everyone
I am using Access 2007 and have found that when I open a report and change
the criteria in my record source the information is not being saved when I
close the query builder. Any suggestions, thanks.
Maxine
--
Message posted via http://www.accessmonster.com
maxjake via AccessMonster.com wrote:
> I am using Access 2007 and have found that when I open a report and change
> the criteria in my record source the information is not being saved when I
> close the query builder. Any suggestions, thanks.
See if you are trying to do it while it is running. Make sure you are in
design view (yes is it possible to be in the report what appears to be
design view, but not).
You also may want to save the query to a named query. That way you
don't loose it. Just hit the save button before you return to the report.
Last trick, open the report. Then open a new query. Get your query the
way you want it. Switch to SQL view. Copy the SQL. Switch to the
report, paste in the RecordSource.
Be sure to check to see if you have the latest version of 2007 (any
updates, et al.) Some early versions has some strangeness.