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
titorober23Asked:
Who is Participating?
 
Jeffrey CoachmanConnect With a Mentor MIS 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
 
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
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
SheilsCommented:
how are you opening the report
0
 
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:
;-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.