In Access 2000, in a report with more than one subreport, when making a change to one of them and then saving it after having saved it previously, the subreport changes to a white box (as in the older access). In the properties data tab, the source object changed to the source object of another subreport.
I have used subreports extensively before and never had this problem. I tried various troubleshooting routes and under some circumstances this happens with only two subreports. The subreports are linked to the main report and are not nested.
Currently, I worked around the problem by setting the Source Object for each of the subreeports in VBA on the open event. The report then works fine. However, I cannot get it to save with the correct source objects and that makes it difficult to maintain.
I tried compacting and repairing the database to no avail. This is a split database with the tables linked to the .mdb that contains all the queries, forms and reports.
Any ideas will be greatly appreciated.
I have used subreports extensively before and never had this problem. I tried various troubleshooting routes and under some circumstances this happens with only two subreports. The subreports are linked to the main report and are not nested.
Currently, I worked around the problem by setting the Source Object for each of the subreeports in VBA on the open event. The report then works fine. However, I cannot get it to save with the correct source objects and that makes it difficult to maintain.
I tried compacting and repairing the database to no avail. This is a split database with the tables linked to the .mdb that contains all the queries, forms and reports.
Any ideas will be greatly appreciated.
