Need help to link pictures in a form

[stepwaec]

Case:
Employee Database

• Table: Betriebspersonal

• Primary Key: Personalnummer (Number)

• Pictures of the employees in a folder (PictureFolder/Personalnummer.jpg)

• Query with the link of the picture as text (Pictures: "PictureFolder\" & [Betriebspersonal]![Personalnummer] & ".jpg")

• Form that should show the picture and further Information about the employee

Problem
How can I link the employee pictures automatically to the form?

I thought this should actually be quite simple to realise but I couldn't find a specific solution to my problem on google. so I hope some genius can help me.

Thanks,
Stephan

[apr pillai]

1. Create an Unbound Image control (select it from the toolbox and draw it on the Form in the required size) on the Employees Form.
2. Change it's Name Property value to Photo.
3. Copy and paste the following VBA Code into the Employees Form VBA Module:

Private Sub Form_Current()
Dim ximg, path
    path = "C:\picturefolder\"
    ximg = Me![employeenumber]
    Me.Photo.Picture = path & ximg & ".jpg"
End Sub

Correct the above Code whereever change required to match the foldername, employeenumber etc.

When you move the employee records on the Form one after the other their pictures will appear on the Photo control automatically. The picture name should match the employee number with .jpg file extension like: 12345.jpg.

Learn another trick with pictures from this link: Run Slide Show when the Form is idle

[stepwaec]

Thanks for your help. It worked

I just used the "image" icon instead of the "unbound object frame" as it didn't work with the unbound object frame.