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

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

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.

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

Thanks again

Rob