printing labels with different photos from form

[hmanvel]

I am working on a simple database and form for generating stickers for inventory, each with a little photo of the part with name and part number. Using the method of a text field in the database with the path to each photo on local hard drive. I have a form designed that generates 2 x 5 forms for printing out on an avery sticker sheet. If I scroll thru the individual forms, the photos update correctly. However if I do a print preview of the entire sheet of 10 stickers, they all have the same single photo. I know there must be a simple way to instruct it to update the photo for each of the forms on the page, but can't find the place to do so. Advice???

 

[HiTechCoach]

I would urge you to use a report, not a form for printing.