Pictures in a sub-report
Posted on 2014-09-10
I have two tables... main table and sub table. In the sub table I have an attachment field. In the attachment field I have 8 jpg files.
Then I have two forms. A main form and a sub-form. The main form has a record ID as does the subform. This record ID field is the link between the main form and the subform.
In the subreport detail section I have an "image block". The control source of the image block is "Picture" which is a field in the sub table.
But when I do a print preview of the main report I get the first picture over and over again... 8 times instead of each picture one time.
What am I doing wrong?