combo box afterupdate

[siCIVIC1986]

Hi All

I am currently creating a database which can be used at my company to store clients addresses logos and contact information.

I have used one of the templates that came with access 2010 and it works perfectly so far but I am having a problem with the logo part.

I would like it so that when a combo box (cboCO) is selected with a company name this then shows the company logo in a picture box (imgPic).

Not only do I want the combo box to show the logo but also I need it so that the user can enter another company if it doesn't exist in the combo list and then also be able to attach a logo that would go with the new company entered.

Is there an easy way of achieving this?

I would appreciate it if somebody could help

Thanks

Simon Knott

 

[siCIVIC1986]

Hi Pat

Thanks for your reply, I have a few questions if you wouldnt mind answering please?

• 
  The separate picture control that you speak about is this not just a picture box that I set and then the code in the AfterUpdate event does something along the lines of:
  
  
  

  Me.imgPic.Picture = Me.cboCO.Column(2)[COLOR="Red"]*[/COLOR]

  *Column 2 contains the company name which is the same name as the correct corresponding picture

• 
  The NotInList which event should that be set in, and how does the user type in the value as at the moment they only have the scrolling combo box selections to choose from (that I have made available by table/query)

Thanks

Simon Knott