Linking photos to a record

[TheBeginner]

im creating a databse and want a to hold photos of indivdual members. i have created a members form with all the members details and for identification purposes i want and image of the member to appear on the form. obviously there are many members so i dont want the same image comming throughout the DB.

at the moment i have created an unbound image, this requires the user to double click the object area to view the image but i want the image to appear automatically!

Please can sumone help!!!!!!!!!!!!!!!

 

[hymn]

the experts here addvise people not to store photo's in your db's. They consume too much space, but to link to your photo's

You need an image box ("imgPicture&quot and a textbox placing on your form
A text field ("Link&quotin your table to contain the link
A button to get your current photo

Attach Command2 code to your button and Form_Current on your On Current event

=====================================
Private Sub Command2_Click()
Me!imgPicture.Picture = Me!Link
End Sub
=======================================
Private Sub Form_Current()
Me!imgPicture.Picture = Me!Link
RefreshDatabaseWindow

End Sub
=======================================
You can amend this to suit your db



Hope this helps
Hymn