C
Carl Imthurn
I've searched the above newsgroups to no avail for a solution to my situation, so I need some help. Apologies in advance for cross-posting.
I have a form (frm-PrimaryRecord) with (among other controls which are not germane to this problem as far as I know):
a combo box (cboPhotoDescription)
and
a bound object frame (fraPhotograph)
the combo box's ControlSource is a query (qryForPhotographComboBox) which has three fields:
UniqueNumber -- a unique id for this photograph
PhotoDescription -- a description of the photograph
PhotoImage -- the photograph itself stored in a field of datatype OLE Object in an underlying table
What I would like to do is display (in the bound object frame on the form) the photograph corresponding to the record selected in the combo box.
The bound object frame's ControlSource property is [Forms]![frm-PrimaryRecord]![cboPhotoDescription].Column(2) which would correspond to the photograph in the PhotoImage field of the query because the Column index is zero-based. However, when I select one
of the combo box records, the corresponding photograph does not display in the bound object frame.
Am I missing something simple? Can you update a bound object frame from a field of a query which is the control source of a combo box? I pull up the table the query is based on and the photograph is definitely there. I'm fairly new to working with OLE
Objects, so any and all advice/suggestions/etc. will be gratefully accepted.
Thanks in advance --
Carl
I have a form (frm-PrimaryRecord) with (among other controls which are not germane to this problem as far as I know):
a combo box (cboPhotoDescription)
and
a bound object frame (fraPhotograph)
the combo box's ControlSource is a query (qryForPhotographComboBox) which has three fields:
UniqueNumber -- a unique id for this photograph
PhotoDescription -- a description of the photograph
PhotoImage -- the photograph itself stored in a field of datatype OLE Object in an underlying table
What I would like to do is display (in the bound object frame on the form) the photograph corresponding to the record selected in the combo box.
The bound object frame's ControlSource property is [Forms]![frm-PrimaryRecord]![cboPhotoDescription].Column(2) which would correspond to the photograph in the PhotoImage field of the query because the Column index is zero-based. However, when I select one
of the combo box records, the corresponding photograph does not display in the bound object frame.
Am I missing something simple? Can you update a bound object frame from a field of a query which is the control source of a combo box? I pull up the table the query is based on and the photograph is definitely there. I'm fairly new to working with OLE
Objects, so any and all advice/suggestions/etc. will be gratefully accepted.
Thanks in advance --
Carl