Company logo in report

[bakerboy_1111]

Hello all,

I've made quite a few reports for my company and each one has the company logo stored in the report header as an image.

I also have a job title and number in the heading that just describes the current job.

The problem is that firstly, I've added the logo top every report and therefore it is stored about 20 times! The other problem is that if I wish to change the job title, then I have to edit the report each time. This is fine if I am doing it (because I made the report) but I'd like to avoid this so that other users aren't involved in too much editting etc.

My idea is to have a table called "Job_Info" with the following fields: "Job_Logo", "Job_Title", and "Job_Number".

In this table I can store various different job names, logos numbers etc. eg

[LOGO1], First Job, 0001
[LOGO2], Second Job, 0002
etc.

I then wish to create a query and form which allows the user to select one of these records (current job).

I then would like to try and get these three fields to appear in the report header, including the logo. At the moment, the main report info comes from a seperate query.

I'm having trouble calling the information from the table. I get error messages saying cannot find field. I assume this is because the info I'm calling is in a table seperate to the main query.

Is there any way I can call this table (or query) which adds the currently selected company logo and info?

Thankyou to anyone that helps,

Bakerboy

 

[samonwalkabout]

You can add unbound text boxes to your report then set the Control source to lookup a textbox on a form.

=[forms]![yourform]![fieldwanted]

The fields don't have to be in the record source of the report they just need to be on an open form, which can be where the reports are triggered from or a hidden form.

You can either use these fields directly in your title or hide them and ref them in another unbound txt box

="this is the title of my report" & [title] & " for the date " & [date] & " ."

Not sure about the logo but I guess something similar can be achieved.