I am trying to create a subform that will display images related to the
parent form. The subform is a continuous form as there will be several
images that relate to the parent form.
I checked Access help and it gave me the following code, which I have
adapted for my database and it works well as a SINGLE FORM.
Option Compare Database
Private Sub Form_Current()
On Error Resume Next
Me![imgfootage].Picture = Me![image]
If Me![image] = "" Then Me![imgfootage].Picture =
"m:\macfiles\library\noimagefound.jpg"
End Sub
Private Sub Image_AfterUpdate()
On Error Resume Next
Me![imgfootage].Picture = Me![image]
End Sub
However, if I change the subform to CONTINUOUS, it will display the
same image on all of the records displayed in the form.
I tried changing the subform detail's Current and AfterUpdate
properties, but lo, no such properties exist for the detail.
Conventional wisdom seems to indicate that this cannot be done on a
subform in continuous form mode. I think there HAS to be a way. A
search of this group seems to bring me close to a solution, but they
don't seem to apply entirely to my situation and I am not good enough
(yet) to bridge the gap in my application.
Thanks for any help anyone can give.
vidiot