I recently updated my Access 2007 database to allow images to be displayed in a form. In order for this to work, the path to the image file must be typed in a field, what I am calling ImageName.

The images are numbered the same way as they are in the database. What I want to be able to do is pull the image number from one field, and "wrap" the path information around it in another field. Something like this:

...