View Full Version : pictures


jasper
04-09-2000, 12:18 PM
I have a database that has a photo field. the photo field has the path of the actual photo. exp. c:\datacard\photos\me.jpg In the access form i would like to display the photo that goes along with that record. if you need more info just let me know. thanks

Carol
04-09-2000, 01:56 PM
There are many ways to attach a photo to a form. For you for display the related records photo, it must be related to the record either within the same table or joined by a query, then everytime you call that record the photo will come up. One way to do this is to have an unbound combo box on your form with its underlying record source set to the unique number/name of the record you want shown. Once a record is selected, then all fields within your form will be updated with the corresponding information, including the photo by an event procedure on the After Update of the combo box. Your forms recordsource would either be the table if you include a field for the corresponding photo or the query. For the actual photo, create a Bound Object Frame with its control source set to the photo field name. If you do not want users editing this photo, then I would suggest locking it.