Linking a Picture to a Combo Box Selection

  • Follow


On one of my database forms is a field called "Admin_Comp", which tells us 
which company is responsible for each record displayed on the form.  I have 
been requested to add the company logos to the form, such that when a user 
goes to a record where "Admin_Comp" is set to company "XXX", then that 
company's logo shows up on the form.  "Admin_Comp" is displayed in a combo 
box who's row source is a simple list (i.e. "XXX", "YYY", "ZZZ")

I have created a small table (there are only 3 companies involved) that 
includes a primary key, the company name ("XXX", etc), and the company logo 
in an OLE object field.  I know you shouldn't hardwire pictures into the 
database, but again, there are only 3 of them, so it should not make a huge 
size impact.

What control should I use to display the logo on the form?  How do I get 
that control to link to the drop-down ("Admin_Comp") that shows the 
responsible company?

Thanks,

Eric

0
Reply Utf 6/7/2007 8:46:00 PM


0 Replies
649 Views

(page loaded in 0.041 seconds)


Reply: