• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 222
  • Last Modified:

How to fix a report broken link

i designed a report, which was working fine, the recordsource was based on a query, after i redesign the db, i delete 1 table and change some fields, so obviously the report was giving me some errors, so i change all the broken links, the report is showing all the proper and correct fields, but whenever i call the report is still asking me for those old fields. even i fix the broken links, the report is still asking me for those deleted fields.
what else can i do to fix this.

best regards
0
titorober23
Asked:
titorober23
  • 5
  • 3
  • 2
1 Solution
 
SheilsCommented:
Sounds like there was some event procedures that were liked to the old fields. Check the event tab of the report property. See if there is and event procedure in the on open or on load.

Also what are you using to open it. A button I guess. If so what did you use to set the command macro or vba
0
 
titorober23Author Commented:
i check all that and fixed, but it's still asking me for old parameters when i call the report
0
 
SheilsCommented:
how are you opening the report
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
titorober23Author Commented:
a button with vba code, i check that and there is no reference to the old fields that i delete
0
 
SheilsCommented:
OK try to open the report from the database window That will tell you if the problem is in the form or the button.

If you have the same problem with the form, try to open the query

This exercise will tell us exactly where to look for the problem
0
 
titorober23Author Commented:
the report use some parameters based on a form, so i have to open from the form's button
0
 
SheilsCommented:
then check textboxes from which you are extraing the parameters and make sure their links are fixed.

Having said that you can still open the report from the database windows as it will preserve the parameters until you change it again by reopening it from the form. Unless you have inserted a code to remove them when you close the report
0
 
SheilsCommented:
You may have also changed the names of the textboxes in the form and fail to make the changes in the vba
0
 
Jeffrey CoachmanMIS LiasonCommented:
titorober23,

Check the Sorting and Grouping Dialog box as well.
You may have set up Sorts or Groups for some of the fields that no longer exist, so you will have to delete them from here as well.

Jeff
0
 
Jeffrey CoachmanMIS LiasonCommented:
;-)
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 5
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now