Changing Report Control Source (Acc97)

Topic

New Reply

Thanks for everyone’ s help on an earlier issue. Now another beginner question:

I have created a report that prints all of the records in a table, and messed around with the formatting in design view until it is how I want it. I’d like to copy this formatting of the fields and labels to use for other reports that are based on queries. I have created a duplicate report, but I haven’t been able to change the fields correctly yet.

0. Is there a way to create a new report based on the formatting of an existing report, but using different data?

1. Assuming you copy an existing report, is there a way to change the source of data universally for a report? (I.e. change the source of all data from Table Blah to Query BlahBlah) I was not able to immediately see a way.

2. If it needs to be done for each field separately – If I go into the Text Box popup for a field, in the Data field I assume I want to change the Control Source. But when I change the Control Source from
Subject
to
=[Query1]![Subject]
which is the syntax pasted in by the Expression Builder, when I try to view the report preview, it pops up a parameter box (when Query 1 doesn’t have one) and then returns #Error in the Subject field.

Any thoughts? I’m assuming something in the syntax of the Control Source is incorrect, but I don’t know what it is.

Thanks a bunch.

Reply | Quote

Replies

While in report design place your cursor in the box at the junction of the two margins in the upper left. This is the place to select the report. Right click, properties, record source. Then use the down arrow to select your new query. I usually create a new query for each report. That should get you started.

Reply | Quote

If you have a base report that can use a number of different record sources then all you would have to do is to just change the record source (assuming all your fields are the same name). You can change the record source in the OnOpen event of the report.
HTH
Pat

Reply | Quote

Tom and Pat – thanks a bunch! That was exactly what I was looking for and more than I had hoped for. Much appreciated.

Reply | Quote