loading a picture into a report

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

I have a form that I enter the information into and it
loads a picture from a file every time the record changes
to a new one and when the form opens.

I just made a report so that I can print the info that is
displayed on the form (only the record that is displayed).

However I am having trouble loading the picture on the
report. Every thing else loads fine and it prints only
the record that I want. I know that you can display the
text that is on a form by doing something like:
=Forms![MyForm]![FieldName]
I tried to do this with the picture and couldn't get it
to work. Any suggestions would be appreciated
 
Dan,
Are you basing this report off a table or a query? If you only want the report to show the current record you are on, then create a query with the criteria field pointing to that record or filter your table for the report. Your picture needs to be a field type of OLE object (embedded or linked picture) in your table, which it sounds like you already have. Then include a field on the report where the control source is your OLE Object.
 
Back
Top