Select a JPG for a report (1 Viewer)

MaleNurse325 · Feb 12, 2019

I have a data input form with drop down list of 9 options. [Media]
On the associated report I would like a jpg associated with the options to be printed. Can this be done please?

Thanks in anticipation

Ranman256 · Feb 12, 2019

the report can have an OLEbound image control
the combo box determines the data in the query.

the query in the report uses the combo:
select * from table where

Code:

=forms!myForm!cboBox

the data in the query has an OLE field with the image.
it will print in the report.

Select a JPG for a report (1 Viewer)

MaleNurse325

Registered User.

Ranman256

Well-known member

Similar threads

Users who are viewing this thread