String the full path to the photo name when inserting photos in a form

[sgrawunder]

Hi to All,
I have a database for a quilt show, we will be registering over 100 quilts and each entry requires a photo for identification.


I have set up the form with a field PhotoID for the path, and then inserted an image field with the control source as the PhotoID field. All works as it should but the path to the photo folder is quite long and it seemed ridiculous to me that I shouldn't be able to have the path as a "constant" and the photo name as a "variable" and then string them together via an OnExit

procedure or macro

or something.
In other words, if I type Photo1 in the PhotoID field it would string the full path to Photo1 to retrieve the photo to the image box.
Does this make any sense LOL???
Thanks for your help,
Sandra

[June7]

Options:

1. hard code path string and concatenate with field in the ControlSource, like:

="string path" & [PhotoID]

2. build a VBA function in a general module that returns the string path and concatenate with field in ControlSource, like:

=GetPath() & [PhotoID]

Function code like:

Function GetPath()
GetPath = "string path"
End Function