Images

I have a table that is linked to SQL server
In this table I have a field that has thepath to an image
C:\Temp\Image\xxx.pdf
What I want to do is have a dropdown that the user can select a Notice Number and then have its image pop up in the form.

I have a Notice Number field and a Path field.

Do I create a Query to query the two fields.
Create a Drop Down box and assign the query to the drop down box.

But then how do I get the image to popup...and in what and unbound object frame?

Any help would be apprecaited

THanks

www.developerbarn.com

Look at this example by AOG it's the simplest I have seen, many props to AOG.

wow 3 forms and a module...going to have to disect this...

me being a novice going to take me a bit...

But thanks for the info...

All I was looking for was simply a drop down box that updates an image...

will write back if I have any other issues and with my results...

THanks for the info...but was jsut looking to populate a picture box with a picture from a field that held the path...

Found it here

http://www.fabalou.com/Access/Forms/pictures_on_forms.asp


Simply:

Me.imgEmpty.picture = "c:\path to picture\" & listboxname.value

Me.imgEmpty.picture = "c:\temp\" & Me.MemberPicture.value