Problem with copied report in Access 2007

[sherry.walker]

I need to create several reports that are exactly the same but get info from
different queries. I can do this with no problem ... just change the source
for the report ... but the copied report still shows the original report name
in the tab when opened. How do I get it to reflect the new report name
instead?

Example - the original report is Employees at CC. I copy/paste and name the
copy Employees at NEC. I then open the report in design view and change the
source and the report displays the correct information. But the tab is still
titled Employees at CC. This will be a problem because there will be 4 or 5
of these and they could all be open at the same time and it's confusing
trying to use the tabs to switch back and forth.

Any help or suggestions will be greatly appreciated!

Sherry

 

[Allen Browne]

If you are programmatically changing the report's RecordSource, you could
also change its Caption property.

But back up a minute. Unless you have all the data in different tables (bad
design), you may be able to solve this just by adding a WhereCondition to
open the report filtered to the appropriate thing.

If using a WhereCondition with OpenReport is new, you just provide a form
where the user selects the appropriate thing (in a combo?)

Here's a couple of examples:
http://allenbrowne.com/casu-15.html
http://allenbrowne.com/casu-08.html
http://allenbrowne.com/ser-50.html

 

[sherry.walker]

The reports are based on queries from a table. What I'm doing is creating
reports for different locations. The user wants to be able to open the
reports in Access and view them.

There will be 8-10 of these and they all need to have the same layout. I can
do them individually, but it would be so much faster if I could just
copy/paste. I'm not changing record source programmatically, but can the
caption be changed that way anyway? And if so, how do I go about doing it?

Thanks for your help!
Sherry

 

[sherry.walker]

Well ... I figured it out. I just needed to use the drop down to change to
the report property sheet and change the caption there. I didn't notice the
drop down at the top before (sometimes think I'm going blind ...).

Thanks so much for your help ... made me start thinking about captions.

Sherry