Different Footers throughout report

[hazelett]

I'm trying to print a maintenance checklist on the bottom of a report. However that checklist can vary based on the machine type. How can I print different checklists at the bottom of my report? I've tried making sub-reports visible/invisible but can't seem to make it work. There is no data involved in the footer, just text and lines

 

[dhookom]

I would put the "just text and lines" in a table that is related to the Machine Type. Then you could use a subreport that is related to the main report. All of this could then be maintained in data rather than design.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[hazelett]

I didn't add a table but I did add an unbound object to the page footer where I linked to forms I created in excel that looks like my checklist. Actually I created two unbound objects each linking to a different checklist. I placed them in the report footer and in the footer format event I made the form visible that I need and made the other one invisible. It works well. Thanks for the help. It is much appreciated. I linked the files instead of embedding them to allow me to make minor modifications to the form without having to change the access report.

 

[dhookom]

Probably not the solution that I would have thought to use but if it works, who can argue.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.