Putting Photo on a form

[Texas ReEntry Services]

I am doing a client tracking db and want to include a phot on the form how
does one go about this?

 

[John B. Smotherman]

I figure you will probably have lots of images? One for each client? To keep
your database small, use a text field in the client table that contains the
fully qualified path to the image (complete path and filename). On the form,
create both a text field with the control source equal to the field in your
table, and an image box, but do not give the image box a control source. In
the Form_Current function in the VBA code for the form, assuming the image
text field is called ImageFileName, include the following code:

Image.Picture = Me!ImageFileName

The image will change to the one listed in the ImageFileName field for each
record.