Need to create user badges with a report

[Channah]

I have a database that I use for the management of several users for a public access TV station. I would like to be able to use photos of the users that we take when they sign up on a report that will create a user "badge" for each user. I have setup my form with a CmdClick that will allow me to search the local drive and input the name of the file into the table for storage. I need to be able to then generate a report for each user that will display the image file that is stored for each of them in the header of the report. I have written a query that will pull only the record for the current user and have set up the report to look to that query but I can't seem to figure out how to link up the picture file. Any help would be appreciated. Thanks

 

[wolfert]

Insert an image in your report.

Enter this code:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.img.Picture = Photo
'img is the image; Photo is the table field refering to the file.

End Sub