Can I write vba code that does what this macro does:

SetValue
[Forms]![Personnel and Training Form]![imgEmployee].[Picture]
[Forms]![Personnel and Training Form]![Photo]

It takes the file path from the [Photo] field and sets the image [imgEmployee] to display it.

Ideally it would also set the [Photo] field to:

"C:\Documents and Settings\tlancaster\Desktop\Photos\no_image.bmp"

if it is empty.

Try this.
You will love it.

:D

Or maybe this will help......