I need some help with a report problem. (Access 2010) My database records my cardmaking business. Each record has details of one card, but may have several alternative options (photos) to that one card in the attachment field. I have various reports based on the main form which includes a photo of the card that I'm sending out. If I'm issuing one of the alternative colour options, I'd like that to show in my report.
When I click on the attachment arrow, I can show the correct option on the screen, but when I send to print (whether pdf or hard copy print) the image reverts to the alternative option.
Can anyone help with this?