Insert a log based on a parameter 1

[Pingwin101]

I have a report in Access that is generated for multiple sites and depending on which site I select within a parameter selection, I want the business's logo to show up.

Right now, I have the same report set up over and over again with the logos specifically embedded in each report.

Is there a way to set up the report so that when I choose the business/site parameter, it will pull the appropriate logo into the report?

I'd rather set up one report vs. 20.

 

[Pingwin101]

OOPS, title should read "Insert a LOGO based on a parameter". I hate it when I do that...

 

[sarduspater]

I think you can make a copy of logoNN.gif into mylogo.gif used in report where NN is a progressive of logo.
If you use openargs() to set this parameter in docmd.openreport and copy of logo in Report_Load() event, it would work.

By,
Renato

 

[Pingwin101]

Thanks, I'll give it a shot!