I'm trying to assign the images defined in a subform's detail records to image placeholders (controls) that are in the main form's report footer section and NOT in the detail section.
I am using a classic Orders / Order Details database.
Ultimately, when I print a record form the main form, I want the image from the subform's first record (an order detail) to be displayed in the parent form's report footer in ImageControl1, the image from the subform's second record to be displayed in the parent form's report footer in ImageControl2, and so on. Each main record can have 1 to 3 subrecords.
Printing the images in the report's details section is not a problem. However, due to formatting and space requirements, this is not an option.
Is this possible? If so, can anyone help?
I am struggling as to how to code this.
Thank you very much, in advance, for any help offered.
Tony
I am using a classic Orders / Order Details database.
Ultimately, when I print a record form the main form, I want the image from the subform's first record (an order detail) to be displayed in the parent form's report footer in ImageControl1, the image from the subform's second record to be displayed in the parent form's report footer in ImageControl2, and so on. Each main record can have 1 to 3 subrecords.
Printing the images in the report's details section is not a problem. However, due to formatting and space requirements, this is not an option.
Is this possible? If so, can anyone help?
I am struggling as to how to code this.
Thank you very much, in advance, for any help offered.
Tony
