Picture box

[31si]

Hello, I was wondering if any of you could give me a hand with this small section of script.

Here is my situation. I have a database with a table in which contains all of the names and members of our club. Every member in our club has a rank, the rank is held in a field called "rank". I also have a form which is used to add and edit the information into this table. The form that i have create is a bog standard form with nothing special on it. What i would like to be able to do is when the form loads and the information from the table populates it, i would like a picture box to hold a picture that represents there position like an avatar. I have tried doing this myself however my attempts just resulted in errors about not have the form focus. I use the code editor to do this. I know this is possible to do as i have seen it on some other projects.

If any one has any idea or hints about how i can do this please reply.
As an added thing i would prefer if it was done in the code editor as the machine it has to run on has macros disabled.

Thanks in advance!

P.S If you would like more information about this please E-mail or PM me

 

[Ethereal]

Assuming that your pictures are regarding their rank I would populate a "rankID" field with numbers ( ID's) representing a Rank, and then make a separate table with all the possible rankID's then a field listing the corresponding rank titles, and another field called rankAvatar which holds the filepath to the image then make sure your image box is set to hyperlinking instead of Embedded, and just set imgBox.picture = filepath every time you load up a record

 

[31si]

Thanks for the reply, I had thought about doing it that way but i have found another way of doing it. I have a combo box on the form and i have created a section of script using the Select case command top pic out he the correct rank and display the picture. Thanks for your help!

 

[Ethereal]

Not a problem, What goes around comes around apply's to Help, These forums are a life saver for me