Help on error '2455' (2 Viewers)

[Pat Hartman]

Did anyone check to see if the Master/Child links were properly set?

 

[The_Doc_Man]

He's got a report with a sub-form. Can you even declare a parent/child link for a mixed construct like that?

 

[MajP]

Yes

 

[Pat Hartman]

Access allows forms to be placed in subreport controls. Access also allows queries. Some of the code in the subform might still run, depending on what events it is in and depending on whether the report is opened in report view or a different view

There is no reason to print forms or to embed forms in reports. Forms are not optimized for printing. Access provides a simple method to convert a form to report. Just use save as and change the type. Then you adjust the code if you need something for printing and remove all the form related code so it doesn't confuse the issue even though it won't run. You don't want the dead code to be left in the class module. If the form has a tab control, the tab control will work if you open the report in report view but not in the other views so if you want to print the report, you will need to get rid of the tab control and embed the subforms directly after converting each to a report.