Name Autocorrect

[cactuspete13]

I am working on a series of reports which are broken down into a set of five: this FY, the last three FYs (using queries to automatically adjust each year), and a cumulative report. This for the larger organization and one set of each for several smaller organizations with the possibility of being broken down even further. I have finished with the details on the main report, just need to work the final details. The problem comes when I try to make the next level copies. Each lower org will have a query that is a copy of the original with different criteria. I am trying to use the Name Autocorrect to go through and change all of the query names in the reports and so on but it's not. I have checked that the query and the report are depending on each other and they are. The only change that is being done is the Record Source. The control sources (all 50-60 of them) are retaining the original query name. The query is pulling information from a couple tables using outer joins

[rpeare]

I don't really have enough information on your structure to give you a good way to go but let's say you have a base query (your combined report), this is the query you want to use for your 50 - 60 smaller groups, let's say that it's 50 -60 stores and you want each store to have their own copy of the 'combined' report but only reflects their data. You do not need to make 50 - 60 queries/reports one for each individual you can have a set of code to cycle through each store and print/produce the report for that store then move on to the next one. This way you'd only need 2 reports. 1 for the aggregate data, 1 for an individual store.

[alcapps]

are you trying to union queries together? when you refer to level, I am not sure what you are referring too.
Grouping in a report. Sub Report?
Usually you have a Main report to hold all the reports and you have several sub reports.
you can union queries and or tables together as well.
Need more info.

[cactuspete13]

I have found a work around for this problem but would still like to try and see if I can get Name Autocorrect to work. Looking back I did leave a confusing explanation. In the table I have date and time columns, one for each. The query has three columns that give me a numerical value for the month, day of the week, and the hour. In the report I have a series of text boxes that go through that query and count how many records where the month value equals x (one for each month so 12 of those), where the day of the week equals y (7 of those), where the hour of the day equals z (24 of those), and more. So if I needed to create a copy of this database for a specific group, for example Team A, copied the query and reports, and renamed the query to TmACurrentFYQ, when I open the report, I have to manually go through each of the text boxes and change CurrentFYQ to TmACurrentFYQ. That's 43 text box control sources that I need per report, times 5 reports.

[alcapps]

usually you can call a vba event on format detail and make all the necessary changes in vba instead of doing that manually. or after some after update of a text box or combo box.

hope that helps..

[rpeare]

Are you talking about changing the record source of the report AND the control source of several fields? If you are you can build your TmACurrentFYQ to have the same field names as your CurrentFYQ so that all you have to do with code is change the RECORD SOURCE of the report itself.