Easy enough,
Add a field to your players table that will store the name of the picture for each player (text). Now make an empty file folder, and put it next to wherever this db resides on your hard drive (or network).
Name this new folder "Pics", and copy into all the pictures you need for your players.
Add a picture to your form in the db, and have it look up anything, it doesn't matter. Change the size mode to zoom. Add a textbox to this form that is bound to the new field you just made. Name the picture img1, and the textbox txtPicPath.
Finally, in this new field, type in the name of the pictures you pasted into your new folder. Don't type in anything but the name of the file itself, so for c:\files\dbs\PlayersDB\Pics\Player1.jpg, yu would just record "Player1.jpg".
Finally, use code like the following to refresh the images source with the approriate file acquired from the new field:
Code:
Private Sub Form_Current()
On Error Resume Next
myPath = Application.CurrentProject.Path & "\pics\"
img1.Picture = myPath & txtPicPath
End Sub
This method will figure out the location of your db, so as long as you keep your pics in a folder called "pics" right next to the db, they will always be found. If you were to record the full pathname of the pictures, and then move the db, they wouldn't be found.
