I have a report named rptMRDDMonthly1. I am using Select Case to display images on it. The images are initials. The controls involved are days and number 1 to 31. If a day in the table has initials, the corresponding image will display on the report. In the example below, if Day1 is populated with the letters AM, then the image imgInitialsSmallAM1 will display on the report.
START of CODE
Select Case Day1
Case "AM"
imgInitialsSmallAM1.Visible = True
Case "AW"
imgInitialsSmallAW1.Visible = True
End Select
END Of CODE
This works well for all 31 days. I use this report as a subreport on a report named rptDailyLogMonthlyPrevious. I put rptMRDDMonthly1 in the report footer. When it opens, the images will not display. I might add that the Select Case statements are in the subreport. I tried them in the main report and had no success either. Do I need to reference the controls differently to make this work?
Thank you.
START of CODE
Select Case Day1
Case "AM"
imgInitialsSmallAM1.Visible = True
Case "AW"
imgInitialsSmallAW1.Visible = True
End Select
END Of CODE
This works well for all 31 days. I use this report as a subreport on a report named rptDailyLogMonthlyPrevious. I put rptMRDDMonthly1 in the report footer. When it opens, the images will not display. I might add that the Select Case statements are in the subreport. I tried them in the main report and had no success either. Do I need to reference the controls differently to make this work?
Thank you.
Last edited: