refresh image on form

[jaykappy]

I have a form that has a combobox....based on the selection if opens a subform with the info...

Say combobox is changed to Mary, Marys info is displayed in the subform....this works fine.


But in the Subform there is a picture that is referencing a field in the table.

I cant figure out how to refresh the picture box when the the combobox changes ...

In the Subform there is:
A Picture box = "Pickup1"
A Textbox with the path (c:\Temp\Images\name.jpg) = "PickupImage1"

I am using AfterUpdate on the combobox and trying to refresh the picture box but getting errors....

Me.[Forms]![frm_V4_MainForm]![frm_V4_PersonalInfo].Pickup1 = Me.[Form]![frm_V4_MainForm]![frm_V4_PersonalInfo].Pickup1Image.Text

NOT WORKING...

Thougths?

[Bob Fitz]

Have you tried to Requery rather than Refresh?

[jaykappy]

Like this?

Me.[Forms]![frm_V4_MainForm]![frm_V4_PersonalInfo].Pickup1.Requery

Main Form = frm_V4_MainForm
Sub Form = frm_V4_PersonalInfo
Picture Box = Pickup1

[jaykappy]

So from the Combobox AfterUpdate....I tried these and all error out

The combobox is on the frm_V4_MainForm and the Picture Box is in the subform (on the main form)....thougth I would have to walk down the forms into the subform

Me.[Forms]![frm_V4_MainForm]![frm_V4_PersonalInfo].Pickup1.Requery

Me.Form.frm_V4_MainForm.frm_V4_PersonalInfo.Pickup 1.Requery

Me.frm_V4_MainForm.frm_V4_PersonalInfo.Pickup1.Req uery

Me.frm_V4_PersonalInfo.Pickup1.Requery

[jaykappy]

Think I got it...I did not have the Control Source of the Pictures set...I set them adn did a refresh and it worked....thanks