need help badly!

I have a database of training for each employee. How can I
attach a photo of each employee to the query that looks
them up by name?

"todd" wrote in message
...
I have a database of training for each employee. How can I
attach a photo of each employee to the query that looks
them up by name?

I have a field in my employee table that contains the location of the
picture. "C:\EmployeePIctures\Fred.jpg"

In the on current event for the form I have:

Me![EmployeePicture].Picture = Me![pictureloc]

You can use the Dir function and a little code to go through the folder that
holds the pictures and add just new pictures.
I place the location in both the PictureLoc field and the Employees name
field, then all I have to do is edit the name as needed.