469,580 Members | 2,007 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,580 developers. It's quick & easy.

Use a COMBO BOX to show a picture

Hi, this must have been asked for before, but I cannot see it.

Hopefully this is very simple.

I have a form which shows everything from a table. In this table is a
picture field called photo. I need to show the picture which
corresponds to the description (which is in another field in the same
table). i.e. the description is the House name, and I need to show the
picture for that house.

The pictures are bmp's and are inside the database.

At the moment I have a combo box on the form which is linked to the
table, and the description field, and a bound picture box. But the
picture does not change when the combo box changes, but it does change
with the record sellector at the bottom of the form.

Any help will be appreciated.

Many thanks in advance

Matt
Nov 12 '05 #1
1 7834
If it is a Bound Object Frame (Access does not have a control called a
Picture Box -- that's in the separate VB product), then it will change when
the record changes, so apparently making a selection in the Combo Box does
not change the record that is displayed (e.g., the Combo Box was not created
using the third option on the first screen of the Combo Box Wizard). If the
picture is displayed in an Image Frame for which the Picture property is set
in VBA code, then obviously that code is not being executed -- perhaps it
should be moved to the OnCurrent event of the Form.

On the other hand, perhaps you want something else entirely. So, if you'd
detail just a little more what you have and what you want to accomplish, we
could offer suggestions.

Larry Linson
Microsoft Access MVP

"Matt Evans" <m4**@lineone.net> wrote in message
news:8f*************************@posting.google.co m...
Hi, this must have been asked for before, but I cannot see it.

Hopefully this is very simple.

I have a form which shows everything from a table. In this table is a
picture field called photo. I need to show the picture which
corresponds to the description (which is in another field in the same
table). i.e. the description is the House name, and I need to show the
picture for that house.

The pictures are bmp's and are inside the database.

At the moment I have a combo box on the form which is linked to the
table, and the description field, and a bound picture box. But the
picture does not change when the combo box changes, but it does change
with the record sellector at the bottom of the form.

Any help will be appreciated.

Many thanks in advance

Matt

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Daniel Hill | last post: by
2 posts views Thread by Ed via AccessMonster.com | last post: by
8 posts views Thread by CZERNAI | last post: by
2 posts views Thread by http://www.visual-basic-data-mining.net/forum | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.