adding pictures to a form

[Jean-Paul De Winter]

Hi,
I have a database with records of personel.
I have a digital photo of each.
This can be really basic but I can't find a way to add their photo to their
record.
Navigating through the different records should of course show the correct
photo on the record, now I get the same photo on every record.
Thanks for the help!
JP

[Arvin Meyer]

There are several ways to do this, but the preferred way is to store only a
path to the photo in the database. This saves space and allows you to quit
easily update photo(s) without making any changes to data in the database.

Then in a form, you add an Image Control, and set its picture property to
the path in the form's OnCurrent event. Something like:

Sub Form_Current()
Me.imgControl.Picture = Me.txtPath
End Sub

where imgControl is the name of your image control, and txtPath is the name
of the text box whose control source is the field holding the full qualified
path to the photo.
--
Arvin Meyer

"Jean-Paul De Winter" <jp.de...@pandora.be> wrote in message
news:YzE_5.109337$lR2.3...@afrodite.telenet-ops.be...