Linking a Picture to a Combo Box Selection

E

egun

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top