asked on

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

Sheils

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

titorober23

ASKER

i check all that and fixed, but it's still asking me for old parameters when i call the report

Sheils

how are you opening the report

titorober23

ASKER

a button with vba code, i check that and there is no reference to the old fields that i delete

Sheils

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

titorober23

ASKER

the report use some parameters based on a form, so i have to open from the form's button

Sheils

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

Sheils

You may have also changed the names of the textboxes in the form and fail to make the changes in the vba

ASKER CERTIFIED SOLUTION

Jeffrey Coachman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jeffrey Coachman

;-)