How get a scanned image on a report

First of all I have a table named tblSignatures.  The table has two fields...  Initials (short text field), and Signature (attachment field).

On a report I want to populate or make a scanned image appear of the signature scan in tblSignatures.  I have tried this as a control source for the image field but it doesn't work.:

=DLookUp("[Signature]","tblSignatures","[Initials] = '" & [Reports]![rptPurchaseOrder]![txtUserInitials] & "'")

Recommendations?
SteveL13Asked:
Who is Participating?
 
COACHMAN99Connect With a Mentor Commented:
maybe your recordsource should be a QUERY joining two tables on initials, and returning the signature field so you can use it as the control source for the image control.
0
 
COACHMAN99Commented:
is your report linked to the table? (recordsource)
and do you have an image field on the report linked (control source) to the Signature in the recordsource?
if so, the image would be populated automatically.
0
 
SteveL13Author Commented:
The report's recordsource is tblPurchaseOrder so no, it is not linked to tblSignatures.  But tblPurchaseOrder does contain the Initials field.
0
 
SteveL13Author Commented:
Brilliant. Thank you very much. That did it.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.