Multiple images on report dependent on a code

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

My report is a confirmation letter for an event. On the
report it has a picture of the map. 2.5 X 3"

When the report is run it asks for event code, time, etc.

Goal: I need to know how to get different images to fill
in for the picture object dependent on what hotel code is
entered.

So far I have a table called maps. It list hotel code,
actual name, path to image file.

I also have a text field on the report for map that gets
called when I run the map report.

I need to know how to EXPLICITLY make the connection
between the 10 images and the code that is being asked.

The end result would be; the report is executed and they
are questioned for date, time, map code, and then the
correct map would be desplayed with respect to the map
code choosen.

Sidenote: I am using no forms at all. This is a report
attached to a query and the map table for the map code.

Thank you in advance for any help.
 
Reports aren't interactive . . . how do you plan to "question them for
hotel, etc."?

If you include the path and filename of the image in a Control on the
Report, though, and use an Image Control, and either are using a Bitmap or
an Image File type that is handled by the graphic filters, and if the
graphic filters are installed....

Then, if the Control containing the path and file name is txtPath, and the
Image control is imgMap, in the Print event, put

Me!imgMap.Picture = Me!txtPath

and that should do the trick.

Larry Linson
Microsoft Access MVP
 
Back
Top