how do i change the name of a report and still have the report wo

[stevo222]

I took an exsisting database to another location...this location is named
different so I'm trying to change the name of the reports however when I go
into report and right click and change the name the report no longer works.
How do i change the name of the report and have it work with the new name

example.....report name: 75 SFS App Roster
want to change to 35 SFS App Roster
then when i run the report i want it to work but it says: The report name
'75 SFS Appt Roster' you entered in either the property sheet or marco is
misspelled or refers to a report that doesnt' exsist

 

[Joan Wild]

How are you running the report? If via a command button on a form, open the form in design view, select the button, and then open the properties dialog (view, properties). On the Events tab, look at the On Click event. Click on the build button (...) and look at the code (or it may open a macro). You should see the name of the report it is opening; edit that.

 

[NetworkTrade]

well - all the objects in the db are "called" or referenced by their name.
So when you change a report's name then the other objects - like a
query/report/form/contro or whatever can't find it....

You can superficially change its name in terms of its visible caption seen
by users which is found in the properties area without affecting its true
object name - perhaps this is sufficient....

An MVPer might know if there is a cascade feature in a newer version of
Access - thus if one changed an object name it would auto cascade thru-out -
- I don't know about that, and in any case it is obviously not working in
your version....otherwise if you change an object's name you will need to
update references to it also....