Link image control with part name of picture

[wasim_sono]

Dear all

I have Pictures at a particular location say d:\image\1234567802012017.jpg. The name includes Picture name (8digit)+date. I need to use following code in control source of image control:
=Left(("D:\image" & [Forms].[display].[meter_no] & ".jpg"),8)
to pick picture having name with matching name on form filed "meter_no".


but its not working.

Please note that the database is shared by mapping the drive to other users.

[andy49]

=Left(("D:\image" & [Forms].[display].[meter_no] & ".jpg"),8)

should this be...

=Left(("D:\image\" & [Forms].[display].[meter_no] & ".jpg"),8)