Changing from Access 2000 to Access 2007 / 2010

[NPShive]

I'll try to keep this succinct --



Years ago I developed (in Access 2000) a system for tracking our church's finances. When selecting a report to print, the query would request a date to filter out the data needed -- typically, this was a four-digit year (ie "2014"), and for a few reports it is an eight-digit date (ie "12/25/2014").

When the current treasurer changed from 2000 to Access 2007, he found that he now has to enter the date multiple times -- 3, 4 sometimes 5 times -- when requesting the report.

I dug through the layers of reports, queries and tables and I can't figure out why he needs to enter it more than once.

I can give more details, but I was wondering if perhaps this is a known issue changing from one version to another.

Thank you in advance!

[orange]

Not aware of such an issue. Normally you would deal with a parameter eg its name, set its value.

Perhaps some techniques at Martin Green's site would apply.

[June7]

AFAIK, the behavior should be the same. If you want to provide db for analysis, follow instructions at bottom of my post.

I never use dynamic parameterized queries. I use VBA to set form or report filter. Review: http://www.allenbrowne.com/ser-62code.html