Calling gurus of the board

First what you do is store your pictures in a folder preferrably in a subdirectory where your datbase resides.

You don't want to Embed them in your DB as it will greatly increase the size and decrease performance.

In your table for Employee info add another field for the file name of the picture. Here you will enter the Employee Picture file just as it is, for each employee record.

Eg. Employee1.jpg


Now assuming your working with a form, with that table as the control source, place an image control (Image6) on your form.

Paste the code below in the on current event of the form, note the Path and change it to reflect your folder path to the pictures.

now when the form is opened and as you change records it will change the picture according to that referenced in the field

'Code

Private Sub Form_Current()

Dim path As String

If Me.Filename <> "" Then

'path to picture location

path = "C:\My Documents\Mypictures\"

'places image into control

Me![Image6].Picture = path & Me![Filename]

End If



End Sub



You can do the same in the "on Format" event on a report if you want to print also.


Ziggy