Scenario: Have a product form with an "image location" field. The
image property uses this field to display the image.
Problem: If an image location field has been changed, the image will
not refresh, even after putting a "refresh", or "repaint" or "requery"
statement in the afterupdate event. The only way to make it update is
to move to the next record and then move back again.
Private Sub Stock_ImageLocation_AfterUpdate()
If Me.Stock_ImageLocation.Value "1" Then
Me.Image98.Picture = Me.Stock_ImageLocation
Me.Refresh
If Len(Me.Stock_ImageLocation & "") 0 _
And Len(Dir(Me.Stock_ImageLocation)) 0 Then
Me.Image98.Picture = Me.Stock_ImageLocation
Me.Image98.Visible = True
Else
Me.Image98.Visible = False
End If
Else
Me.Image98.Visible = False
Me.Repaint
End If
End Sub
Hope you can help.