Copying report structure (1 Viewer)

[mcreedie]

I have a report which will contain many different entries which gets the info from one query. As there is so many different entries I want to be able to copy the structure of the report but replace the query with one that is the same but for a different area.

So my queston is how do I cahnge the source of the report whilst retainging the structure?

Many thanks in anticpation,

Rob

 

[llkhoutx]

Open the report in Hidden view, change the recordsource in VBA, then open the report in normal view.

 

[Chris RR]

I set up a new query with exactly the same column names. That might be the hard part, but often it's just the criteria that change, so it's just a quick copy-and-change.

Then I do a 'save as' of the original report, to a new name. In the "new" report, just change the record source in the Report Properties.

For straightforward reports, that's all.

 

[mcreedie]

Many thanks to all of you on the ball people, you hav helped me crack it.

Thanks again

Rob