Anyone know of a way to display an image based on the current record.
Example, I have a form that shows current products that I sell. The form displays one product at a time and each profduct has 10 fields of data, I have all the images of the products (all the same size) stored on my network drive in lets say Z:\images\products
Is there a way to say "Z:\images\products\"&[FiledName]&".jpg"
The image will be named lets say product 1234
Image would be named Z:\images\products\1234.jpg
I would like when I go to the next record for the image to change to that product picture. I want the form to know that when it sees 1234 in the field name that it should show the image from the z:\ drive.