How can I use a different picture with each report I print?

S

Scott

I am trying to use a differnt picture to appear when I run my reports. How
do I set this up in forms, and so forth. I want to have a list in forms and
select which picture I would like to insert into my report when I run it.
 
C

Carl Rapson

Do you mean use the picture to set the report's Picture property? If so, you
could try the following:

1. Populate a combo box with the list of picture file names

2. Call the report, passing the picture file name to the report in the
OpenArgs parameter:

DoCmd.OpenReport <report name>, acViewPreview, , , , <combobox control
name>

3. Set the report's Picture property in, say, the Detail_Format event:

Me.Picture = Me.OpenArgs

HTH,

Carl Rapson
 
Top