Changing Source Query Name

[chastst]

I have on a couple of occasions written a report, and changed the name of the source query at a later date (either by choice or by an error). Is there a way to update the source of a report without having to re-write the whole report? Also would work for a duplicate report that pulls from a different source query. Thanks

 

[Chris RR]

Have you tried bringing up the properties for the entire report & just changing the Record Source? If your field names are the same, you should have no problem.

 

[charityg]

open the report in design view and click the properties button on the toolbar. Then click the data tab and change the recordsource to name of the new query. You can either select the name from the dropdown, or you can build a new query on the fly by clicking the ... button.
looks like i was replying at the same time

[This message has been edited by charityg (edited 05-14-2001).]