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