Image in Form 1

[kbSES]

I am new to Access VBA and I think this is something easy to solve. I'm trying to work with images in forms. I have a form with two combo boxes: Company and Contact (Contact is based on Company and that works fine). BUT, I am trying to get the image associated with the Company and contact to pull up and all I get is the first one every time. The form is just based on the one table that contains the link to the image. I have been trying to get this working for about a week and any help will be much appreciated!

Thanks!!!!

 

[CaptainD]

Post your code

 

[ck1999]

Most likely the form should not be bound? and then use a dlookup on the combobox change to change the picture

If is a bound form then changing the combobox will only change the current record and it is not moving to the perceived selected record.

ck1999

 

[kbSES]

Please send me your e-mail address so I can post. I signed up for box.net and I'm not sure how to do it.

 

[ck1999]

enviroserve at juno dot com

ck1999

 

[TheAceMan1]

How are ya kbSES . . .

Have a look at [blue]DLookUp![/blue] . . .

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886