open image file trough a button in form

[raffi]

hello i just recently learned by placing the folder location within a text field, it would bring up the picture into the form when i open that record

how can i make the the image file actually run right through a form via having its location placed within the text field in a form



example each record would have a text field like this, (C:/documents/pictures/panda.jpg

and i can change records in a form and once i click maybe on a button it would have a macro where the text field would run command run the jpg format picture file so i may watch the picture closely

[June7]

Not sure I understand what you mean by 'run the jpg' and 'watch the picture closely'.

To dynamically display images, use an Image control and set the ControlSource property to the field with the path\filename. No button and no code needed.

Is this a multi-user database?

[raffi]

only for me,

ok i have an item table, i have many records in it, each record contains item name item code and also a text field,

i have placed the picture location in the text field, which looks something like this, C:/documents/pictures/item0059jpg

i created a form with the item table and combobox so i search items, i want a button where it will run the C:/documents/pictures/item0059jpg <----- this image file will open, as if i double clicked on it,

i basically want to be able to open images file trough my text field which has the location written in it, and the way it opens is as if i have double clicked on the image file with a mouse on the desktop, by hitting a button and the source of where the image file will be in the record

[June7]

To open the image in its native program (like Windows Photo Viewer), try setting the textbox on form as a Hyperlink.

Or consider: http://allenbrowne.com/func-GoHyperlink.html

You want to allow user to select a file and populate the field with the path\filename? Use FilePicker dialog. http://msdn.microsoft.com/en-us/libr...ffice.11).aspx